Click above to get retro games delivered to your door ever month!

lcalcmode()                                                        MISCWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   Set calculation mode

 Syntax
   Lcalcmode( aSpreadsheet,cMode )

 Parameters
   aSpreadsheet - Spreadsheet handle array
   cMode        - Calculation mode
                  (A)utomatic
                  (M)anual
                  (B)ackground

 Returns
   nStatus      0  All ok
                6  Invalid parameters

 Notes
   The calculation mode determines how often a spreadsheet's formula are
   recomputed.  In you choice (A)utomatic, the spreadsheet will update all
   formulas as soon as a cell value affecting the formula is changed.  If
   you choice (M)anual, you need to press a key, (usually F9), to
   recalculate the file.  (B)ackground allows the spreadsheet to be
   recalculated while it is waiting for keystrokes from the end-user.  If
   you create a spreadsheet using CLIPWKS and set the calcmode to (M)anual,
   be sure to have your end-user press F9 as soon they read in the
   spreadsheet.  CLIPWKS does not calculate the values from the formulas
   it writes to the spreadsheet.

 Category
   Creating spreadsheet files