Parse(String,CellReferenceMode,WorkbookFormat) Method

Parses the specified formula value and returns the formula which was created from it.

Syntax

C#

public static Formula Parse( 
   string value,
   CellReferenceMode cellReferenceMode,
   WorkbookFormat fileFormat
)

Parameters

value

The string which defines the formula to parse.

cellReferenceMode

The mode used to interpret cell references in the formula.

fileFormat

The file format to use when parsing the formula. This will be used to determine certain limits which are format dependant.

Return Value

A Formula instance which represents the formula specified.

Exceptions

Exception	Description
System.ArgumentNullException	value is null or empty.
System.ComponentModel.InvalidEnumArgumentException	cellReferenceMode is not defined in the CellReferenceMode enumeration.
System.ComponentModel.InvalidEnumArgumentException	fileFormat is not defined in the WorkbookFormat enumeration.
FormulaParseException	value is not a valid formula.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+