Version

Search Results

ApplyTo(WorksheetRegion) Method

Applies the formula to the specified region of cells. Syntax Parameters region The region of cells to apply the formula to. Exceptions Exception Description System.ArgumentNullException region is null. System.InvalidOperationException region contains an array formula or data table which extends outside the region....

ApplyTo(WorksheetRegion[]) Method

Applies the formula to all specified regions of cells. Syntax Parameters regions The regions of cells to apply the formula to. Exceptions Exception Description System.ArgumentNullException regions is null. System.ArgumentException regions has a length of 0. System.ArgumentException Not all regions specified are fr...

ApplyTo Method (Formula)

Applies the formula to the specified cell. Overload List

Equals(Formula,Formula,CellReferenceMode) Method

Determines whether two Formula instances are equal using the specified cell reference mode. Syntax Parameters formulaA The first Formula to compare.formulaB The second Formula to compare.cellReferenceMode The cell reference mode to use when comparing the two formulas. Return Value True if the formulas are both nul...

Equals Method (Formula)

Determines whether two Formula instances are equal using the specified cell reference mode. Overload List

Parse(String,CellReferenceMode) Method

Parses the specified formula value and returns the formula which was created from it. Syntax Parameters value The string which defines the formula to parse.cellReferenceMode The mode used to interpret cell references in the formula. Return Value A Formula instance which represents the formula specified. Exceptions...

Parse(String,CellReferenceMode,CultureInfo) Method

Parses the specified formula value and returns the formula which was created from it. Syntax Parameters value The string which defines the formula to parse.cellReferenceMode The mode used to interpret cell references in the formula.culture The culture used to parse the formula. Return Value A Formula instance whic...

Parse(String,CellReferenceMode,WorkbookFormat) Method

Parses the specified formula value and returns the formula which was created from it. Syntax 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 de...

Parse(String,CellReferenceMode,WorkbookFormat,CultureInfo) Method

Parses the specified formula value and returns the formula which was created from it. Syntax 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 de...

Parse Method

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