NExS.app Worksheet Reference

The NExS.app worksheet is a special worksheet in your Excel file that configures how your app works. This reference documents all available options.

Structure

The worksheet uses a key-value format in columns A, B, and C:

• Section headers (app, view) go in column A
• Options go in column B
• Values go in column C (or D for nested options)
• Comments start with # or //
• Formatting (colors, fonts) on the NExS.app worksheet is ignored, so you can use it for emphasis or readability

The worksheet name is not case-sensitive: NExS.app and nexs.app both work.

Keyword Matching

Keywords and option names are not case-sensitive and may contain spaces. submitList, SubmitList, and Submit List are all the same option, as are cellLocks and cell locks. This reference uses camelCase spellings throughout.

App Section

The app section must come first and defines global settings.

Required

Optional

access codes

chartOptions

sliderOptions

ledOptions

View Section

Each view section defines a visible area of your app. You can have multiple views.

Basic Syntax

The range can be:

• Sheet1!A1:G18 — Specific range on a sheet
• Sheet1 — Entire worksheet
• A1:G18 — Range on the first sheet
• MyNamedRange — A named range from Excel

View Options

Editable Cells

Examples:

Editable cells must be inside the view’s range. Don’t also make an editable cell a button: a button cell is no longer editable.

Chart Definition

Charts overlay a range of cells within a view.

Chart Options

Chart Types: column, bar, line, area, pie, stacked column, stacked bar, stacked line, stacked area, legend

Chart Styling Options

Slider Definition

Slider Options

LED Definition

LED Options

Cell values: red, green, yellow, blue, or any other value for “off”

Button Definition

Button behavior is defined in the cell content.

Button Content Syntax

Label {action: parameters, property: value}

Button Actions

sendData replaces the deprecated SubmitButton feature.

Each cell lock cell is 0 when the app is created and returns 1 once it is locked, so formulas can read lock state, for example to disable a button for a slot that is already taken.

Button Properties

Button Macros

Button Examples

# Simple navigation
Next {setView: 'Page 2'}

# Form submission
Submit {disabled: %REQUIRED, sendData: 'A1:C10', setView: 'Thank You'}

# Styled button
Click Me {bg: 'steelblue', fg: 'white', fontWeight: 'bold'}

# Dynamic (using formula)
="Submit {disabled: " & IF(B1="", "true", "false") & "}"

# With confirmation
Delete {confirm: {message: 'Delete all data?', ok: {setInputs: ['A1:A10', '']}, cancel: {}}}

Complete Example