Spreadsheet and Table Options

Spreadsheet and table section options specify section, cell/column properties, formatting and Header formatting options:


1 - Section options (section type and name)

●     Name - name of section, can be used in another section formulas

●     Size - section size (height and width)

●     Visibility - formula that evaluates to boolean value, for example =A > 10

●     Hide mode - hide: section is hidden but present can be used in other formulas calculations, no data: section is not rendered cannot be used in calculations

●     Auto width - width of the section relative to the size of the window (1/6 means that section will have width one sixth of window width) 

●     Fixed size - after setting the wight of section, it can no longer be changed in app

●     Wrap content - wraps cells content

●     Editability - sets whether the user will be able to change the contents of the section

●     Data - name of data object bound to section (read only)

●     Filter - filter formula, to lookup for data elements bound to this section

●     Refresh mode - determines when and how section will be refreshed 

●     Allow add rows - Table section only, end user can add remove rows from table

●     New row formula - lookup formula for new row


2 - Cell/Column options

●     Cell type - type of cell, formula in side have to match cell type

●     Size - cell size (height and width)

●     Editable - if not, cell will be computed

●     Placeholder - text, which appears in cell when cell is empty

●     Data field - if section is bound, this is field/column on target data object to update value on save to database step

●     Alias - cell alias, aliases can be used in other formulas

●     Hint - comment for end user

●     Header - header name or formula (table only)

●     Visibility - header visibility formula (table only)

●     Sort - column sort direction (table only)

●     Header style - style of header

●     Blank if zero - if in cell is 0, cell is empty (cell type number or currency)


3 - Cell formatting options


4 - Table column formatting options


Have more questions? Submit a request


Article is closed for comments.
Powered by Zendesk