getRecalculateFormulasOnNextOpen - cfsimplicity/spreadsheet-cfml GitHub Wiki

Returns whether all formulas in either the entire workbook or the specified sheet will be recalculated when the spreadsheet file is next opened (in Excel).

getRecalculateFormulasOnNextOpen( workbook, [, sheetName ] )

Required arguments

  • workbook spreadsheet object

Optional arguments

  • sheetName string: if specified returns whether formulas in that sheet will be recalculated (instead of all sheets in the workbook)

Return value

boolean

Chainable? No.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.setCellValue( workbook , "72", 3, 4 ); /* set value of cell */
spreadsheet.setRecalculateFormulasOnNextOpen( workbook , true );
spreadsheet.getRecalculateFormulasOnNextOpen( workbook ); //true