Click above to get retro games delivered to your door ever month!
[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lcalcorder() MISCWKS.PRG
------------------------------------------------------------------------------------------
Purpose
Set calculation order
Syntax
Lcalcorder( aSpreadsheet,cOrder )
Parameters
aSpreadsheet - Array of spreadsheet parameters
cOrder - Calculation order
(R)owwise
(C)olumn
(N)atural
Returns
nStatus 0 All ok
6 Invalid parameters
Notes
Calculation order determines when dependent cells are recalculated in
order to resolve any formulas. Natural calculation order means that
before a formula is computed, each cell it refers to is calculated
first to ensure accurary. In column recalculation order, calculation
starts in the first column and proceeds down. It ignores formulas in
other columns. Rowwise works similarly, calculating rows at a time.
The preferred method is (N)atural.
Category
Creating spreadsheet files