Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- CLIPWKS -Spreadsheet Library - <b>lcalcorder()</b> <b>miscwks.prg</b> http://www.X-Hacker.org [<<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

See Also: Lcalcmode()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson