recalculateAllFormulas - cfsimplicity/spreadsheet-cfml GitHub Wiki

Clears the formula cache and immediately re-calculates all formula cells in the specified workbook.

recalculateAllFormulas( workbook )

Required arguments

• workbook spreadsheet object

Chainable? Yes.

Related

setRecalculateFormulasOnNextOpen, getRecalculateFormulasOnNextOpen, setReturnCachedFormulaValues

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.read( path );
spreadhseet.addRows( workbook, data );
spreadsheet.recalculateAllFormulas( workbook );
spreadsheet.write( workbook, path, true );