1. Values
Values in cells
- For more information see Cell value.
V attribute
- values in array
V can be defined in row, default row, column and default column. If defined in column, the values are copied to row on grid start and cannot be later changed in column. The row values are always preferred to column regardless on Important attribute.
V can be defined in three ways, as first character separated string, as array and as object with column ids. The array definition is the fastest way to process.
Which columns and in which order are set by the array or string definition is set by column attribute VIndex, by default it is set automatically according to defined columns order.
U attribute
- values in special UTF8 string
U can be defined in row or default row. It is always string in UTF8Store format. It is very short and fast to process.
Which columns and in which order are set is controlled by column attribute UIndex, by default it is set automatically according to defined columns order, but only for columns with UCode that specifies the type and size of the value.
E attribute
- editable formula
E can be defined in row, default row, column and default column. If defined in column, the values are copied to row on grid start and cannot be later changed in column. The row values are always preferred to column regardless on Important attribute.
The editable formula can be dynamically generated by OnGetFormula API event.
F, Formula and ValueFormula attributes
- JavaScript formula
F can be defined in row, default row, column and default column. If defined in column, the values are copied to row on grid start and cannot be later changed in column. The row values are always preferred to column regardless on Important attribute.
Formula can be defined in row, default row, column and default column. Read only if not defined the F value for given cell. It is read from row before column except if the column has set Important attribute set.
ValueFormula can be defined in cell or default cell. It is calculated attribute.
The JavaScript formula can be dynamically generated by OnGetFormula API event.
Value attribute
- default value
Value can be defined in cell and default cell, row, default row, column, default column. It is read from row before column except if the column has set Important attribute set.
Mirror attribute
- value from another cell
Mirror can be defined only in cell or toolbar cell, but not in any default. It reads value from another cell defined by Mirror / MirrorRow / MirrorCol attributes.
It is read after cell Value, but before row / column Value
OnGetValue API event
- dynamic value generating
If defined, OnGetValue is called on every reading of any cell value, including toolbar values.
- If defined Cfg DefaultValue it speeds up reading cell values and uses this value instead of Value and ValueFormula attributes.
Order
: OnGetValue, E, F, Formula, V, U, DefaultValue, ValueFormula, cell Value, Mirror, row / col Value
E, F, Formula, V can be defined and are read in this order: row, default row, column, default column. There is ignored Important attribute.
U can be defined and are read in this order: row, default row.
DefaultValue can be defined in Cfg tag.
Mirror can be defined only in cell (in A or tool). It cannot be defined in default cell.
ValueFormula can be defined and are read in this order: cell (in A), default cell (in DefCells).
Value can be defined and are read in this order: cell (in A), default cell (in DefCells), row, default row, column, default column. If column has Important attribute, it is read before row.
Toolbar cell
Toolbar cell can read only these items in this order: OnGetValue, Formula, cell Value, Mirror, row Value.