One of the most important and unique qalcwise features is spreadsheet based UI, designers can use two types of spreadsheet based widgets to create rich and dynamic UI.
Right click on the spreadsheet or the table section to manipulate cells and rows.
Fixed size spreadsheet, designer can add/remove rows and columns, change columns and rows height and width, modify multiple cells at once.
Spreadsheet cells are always addressed with ROW COLUMN syntax (for example: A1, B6, AB67) in formulas, when used in another section, add section name in front of cell address (for example: section1.A1, section1.B6, section1.AB67).
Spreadsheet can be bound to one data object, it means that one data object can be displayed in section cells, one data object can be used in cells formulas, one data object can be modified in spreadsheet.
Spreadsheet section bound o SYSUSER, email, name and isactive are SYSUSER columns
Table widget is a spreadsheet with fixed columns and dynamic rows, you can add/remove columns, but number of rows depends on data filter and add new rows option.
In the table, widget cells are addressed with COLUMN only (for example: A, B, AB) in formulas, and this address scope is limited to table row, it means that formula =A+15 will be repeated for each table row. When table column address is used outside of this table section, add section name in front of it and it means whole column array (for example: section1.A, section1.B).
You change column header names and format them (more about formatting).
Table section can be bound to an array of data objects, it means that one data object is bound to one table row. Multiple data object can be displayed and modified in the table section.
When Allow add rows is checked, end user will be able to add new rows to section.
Table section definition, column D formula will be repeated for each row.
Table section preview, 3 object of SYSUSER type are bound, spare row is visible.