ExcelFileDelayFormulaParse Property |

Delays formula parsing until one of SaveXls methods is called.

**Namespace:** GemBox.Spreadsheet**Assembly:** GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1000

Syntax public bool DelayFormulaParse { get; set; }

Public Property DelayFormulaParse As Boolean
Get
Set

#### Property Value

Type:

BooleanRemarks 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