Click or drag to resize

ExcelFileDelayFormulaParse Property

Delays formula parsing until one of SaveXls methods is called.

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version:
public bool DelayFormulaParse { get; set; }

Property Value

Type: Boolean

Old XLS format requires all formulas to be parsed and saved to XLS files as special tokens in RPN (Reverse Polish notation). GemBox.Spreadsheet only knows how to parse limited set of formulas listed at ExcelCell.Formula page. Only listed formulas can be saved to XLS file.

New XLSX (Open XML) format stores formulas as strings and leaves formula parsing to applications that read XLSX documents. Therefore, ALL formulas are supported when writing/reading XLSX files.

If this property is true, each set of ExcelCell.Formula property will just store formula string. When one of ExcelFile.SaveXls methods is called formulas are parsed and exception is thrown if formula is not supported or in bad format. When XLSX is saved, formulas are not parsed, they are just saved as strings. If the formula is in bad format, MS Excel or other application will report an error in formula.

If this property is false, formula string is parsed every time you set ExcelCell.Formula property. You will limit formulas to the ones supported by GemBox.Spreadsheet parser and the exception will be thrown immediately if the formula is not supported or in bad format.

Default value of this property is .

See Also