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

  .