setRecalculateFormulasOnNextOpen

Set a flag to force all formulas to be recalculated the next time the spreadsheet file is opened (in Excel etc).

setRecalculateFormulasOnNextOpen( workbook[, value ] )

Required arguments

• workbook spreadsheet object

Optional arguments

• value boolean default=true

Chainable? Yes.

Notes

Spreadsheets generally cache the results of formulas for performance reasons. If you use the library to modify cell values referenced by formulas, the results may therefore not change.

Setting this flag after making changes will ensure that any formulas are recalculated by Excel (or equivalent) the next time the spreadsheet is opened.