Builder Interface Reference
This page explains the Spreadsheet Form builder interface and the controls available when building a spreadsheet form.
Spreadsheet Launchpad
The launchpad appears before the full-screen builder opens.
| UI Element | What It Does |
|---|---|
| Spreadsheet Builder title | Identifies the spreadsheet builder area |
| Sheet and named cell count | Shows how many sheets and named cells currently exist |
| Open Builder | Opens the full-screen spreadsheet builder |
| Metadata hint | Explains why the builder cannot open, usually because Form Name or Form Prefix is missing |
Full-Screen Builder Shell
| UI Element | What It Does |
|---|---|
| Title | Uses the form name |
| Subtitle | Shows that you are in Spreadsheet builder mode |
| Save as Draft / Save / Create New Version | Saves through the main form save button. The label follows the form status |
| Exit | Leaves the full-screen builder and returns to the normal form editor page |
Esc key | Closes the full-screen builder |
Builder Toolbar: Nav Group
| UI Element | What It Does |
|---|---|
| Selected cell address | Shows the active cell, including the sheet name, for example Sheet1!B3 |
| Jump to field | Lists named cells. Selecting one switches to its sheet, selects the cell, and scrolls it into view |
| No named cells yet | Appears when no cell bindings have been created |
Builder Toolbar: Binding Group
| UI Element | What It Does |
|---|---|
field_name | Internal field name used in submissions, reports, queries, and integrations. It is normalized to lowercase letters, numbers, and underscores |
Label | User-facing label used in validation messages and column headings |
Type | Sets the named cell field type: Text, Number, Date, or Dropdown |
Required | Requires the submitter to fill this cell before final submission. Draft saves skip the required check |
| Apply | Saves or updates the binding for the selected cell |
| Clear | Removes the binding from the selected cell. It does not clear the cell's visible value or layout text |
| Dropdown options | Appears only when Type is Dropdown. Enter one option per line |
Field names must be unique across all sheets in the same spreadsheet form.
Only bind cells that should become form fields. Titles, instructions, section labels, helper formulas, and visual spacing cells should usually stay unbound.
Builder Toolbar: Style Group
| UI Element | What It Does |
|---|---|
| General | Displays the raw cell value without special display formatting |
| Text | Treats the cell as text for display and export |
| Number | Displays and exports compatible values as numbers |
| Currency (RM) | Displays numeric values with RM formatting and exports them as Excel currency |
| Percentage (%) | Displays numeric values with %. A value of 45 means 45%, and the XLSX export converts it to Excel's percentage convention |
| Date (DD/MM/YYYY) | Displays compatible date values as DD/MM/YYYY |
| Format warning | Appears when a selected format is not a good match for the field type |
| Format locked to Date | Appears for Date bindings because date fields use the custom OSPROV date picker and date display format |
Formats are presentational. OSPROV stores canonical values and applies formatting for display and XLSX export.
Builder Toolbar: Sheet Group
| UI Element | What It Does |
|---|---|
| Sheet name input | Renames the active sheet. Sheet names must be unique |
+ | Adds a new sheet |
x | Deletes the active sheet. Disabled when there is only one sheet |
| Sheet tabs | Switch between sheets |
Each sheet has its own grid layout and its own bound fields. A cell address such as A1 can exist on multiple sheets because the sheet context is stored with the field.
Native Spreadsheet Toolbar
OSPROV allows a small subset of the native spreadsheet toolbar:
- Undo and redo
- Font size
- Bold
- Text color
- Fill color
- Left, center, and right alignment
- Border options supported by the allowed toolbar subset
Other native spreadsheet toolbar features are hidden in the builder to keep the form schema predictable.
Grid Area
The grid is where you build the spreadsheet layout.
Supported grid interactions include:
- Select cells and ranges
- Type static text and values
- Type formulas where the spreadsheet engine supports them
- Copy and paste spreadsheet data
- Resize rows and columns in the builder
- Insert and delete rows and columns in the builder
- Merge cells where the spreadsheet grid UI makes merge actions available
- Scroll large sheets horizontally and vertically
If you insert or delete rows or columns after creating bindings, OSPROV warns that cell bindings may have shifted. Review named cells before saving.