GrapeCity.Documents.Excel.InvalidFormulaHandling

InvalidFormulaHandling Enum

Specifies how invalid formulas are handled.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum InvalidFormulaHandling

Public Enum InvalidFormulaHandling

Examples

OpenOptions options = new OpenOptions();
options.InvalidFormulaHandling = InvalidFormulaHandling.Discard;
InvalidFormulaHandling invalidFormulaHandling = options.InvalidFormulaHandling;

Fields

Name	Description
Discard	Discard invalid formulas and their cached values.
DiscardFormulaOnly	Discard invalid formulas while preserve their cached values.
Preserve	Preserve invalid formula text and cached values.
Throw	Throw an exception when an invalid formula is encountered.