TryParse(String,CellReferenceMode,Formula,FormulaParseException) Method

Parses the specified formula value. The return value indicates whether the operation succeeded.

Syntax

C#

public static bool TryParse( 
   string value,
   CellReferenceMode cellReferenceMode,
   out Formula formula,
   out FormulaParseException exception
)

Parameters

value

The string which defines the formula to parse.

cellReferenceMode

The mode used to interpret cell references in the formula.

formula

When this method returns, contains the formula which was parsed from value if the conversion succeeded or null if the conversion failed. This parameter is passed uninitialized.

exception

When this method returns, contains the error information if the conversion failed or null if the conversion succeeded. This parameter is passed uninitialized.

Return Value

True if value was converted successfully; False otherwise.

Exceptions

Exception	Description
System.ArgumentNullException	value is null or empty.
System.ComponentModel.InvalidEnumArgumentException	cellReferenceMode is not defined in the CellReferenceMode enumeration.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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