Skip to content

Spreadsheet Tools

Complete index of all Spreadsheet workbench tools and features.


Core Tools

Tool Description
Create Spreadsheet Add a new spreadsheet object to the document
Import Load a CSV file into a new spreadsheet
Export Save the current spreadsheet as a CSV file

Cell Operations

Tool Description
Merge Cells Combine selected cells into one spanning cell
Split Cell Un-merge a previously merged cell
Set Alias Assign a human-readable name to a cell for use in expressions
Bind Sheet Synchronise a range of cells to a range in another spreadsheet

Formatting

Tool Description
Align Left / Center / Right Horizontal text alignment within the cell
Align Top / VCenter / Bottom Vertical text alignment within the cell
Bold Toggle bold text
Italic Toggle italic text
Underline Toggle underlined text
Foreground / Background Colour Set text or cell background colour

Concepts

Page Description
Formulas and Expressions Formula syntax, functions, operators, and the expression engine
Aliases Naming cells for readable cross-workbench references
Model Integration Driving model dimensions from a spreadsheet and reading model properties