3. Calculation order

When the particular cells / rows / columns are calculated

• If you use in formulas the results of other formulas, you need to set calculation order in that will be these formulas calculated.
• By default there is used alphabetical order, according to column names (not by column position !).
• You have to set in every row its attribute

  CalcOrder

  to comma separated list of all its calculated cells.
• Any cell not listed in CalcOrder will not be calculated, even it has set its Formula.
• To set the same CalcOrder to more rows you can set it to their default row (<D>). Every row without Def attribute has default row named "R".