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
|
  |
0 Comments