setReturnCachedFormulaValues

For the current spreadsheet library instance, allows you to control whether to return cached or freshly calculated formula values. Workbooks generally cache values that have already been calculated.

setReturnCachedFormulaValues( state )

Required arguments

• state boolean

Note

The library default is true which is best for performance and can help avoid exceptions in cases where POI is unable to run a specific formula in your workbook.

Example

spreadsheet = New spreadsheet();
spreadsheet.setReturnCachedFormulaValues( false ); // always re-calculate returned formula cell values