setThrowExceptionOnFormulaError - cfsimplicity/spreadsheet-cfml GitHub Wiki

For the current spreadsheet library instance, allows you to control whether malformed formulas or formula evaluation errors cause an exception to be thrown.

setThrowExceptionOnFormulaError( state )

Required arguments

• state boolean

Note

The library default is false. If a formula error is encountered when reading a cell the value #ERROR! is returned.

Example

spreadsheet = New spreadsheet();
spreadsheet.setThrowExceptionOnFormulaError( true);