These commands allow the user to set other options: the recalc
ulation order, the number of recalculation iterations, and the table
format for the /FileTable command.
Xspread does not support natural order recalculation.
The Options Set command provides the following options:
- byrows
- Recalculate formulas first by row and then by column.
- bycols
- Recalculate formulas first by column and then by row.
- iterations=n
- Set the number of times the worksheet recalculates.
- tblstyle=xxx
- Determine the type of delimiter used when the
worksheet exports to table format. Valid values for
tblstyle are:
- 0
- Colons (:) are used to separate fields, with no tbl control
lines.
- tbl
- Colons (:) are used to separate fields, with
tbl control lines.
- latex
- Tables are formatted to meet LATEX
requirements.
- tex
- Tables are formatted to meet TEX requirements.