Static
$tStatic
nextApplies the formula to all specified regions of cells.
This method, or one of the other ApplyTo overrides must be used to set the value of a cell to a formula.
After this method returns, the WorksheetCell.formula of all cells in all specified regions will return the formula.
ArgumentNullException 'regions' is null.
ArgumentException 'regions' has a length of 0.
ArgumentException Not all regions specified are from the same worksheet.
InvalidOperationException One or more regions specified contain array formulas or data tables which extend outside the region.
The regions of cells to apply the formula to.
Applies the formula to the specified cell.
This method, or one of the other ApplyTo overrides must be used to set the value of a cell to a formula.
After this method returns, the WorksheetCell.formula of the specified cell will return the formula.
ArgumentNullException 'cell' is null.
InvalidOperationException 'cell' is part of an array formula or data table which is not confined to just the cell.
The cell to apply the formula to.
Applies the formula to the specified region of cells.
This method, or one of the other ApplyTo overrides must be used to set the value of a cell to a formula.
After this method returns, the WorksheetCell.formula of all cells in the specified region will return the formula.
ArgumentNullException 'region' is null.
InvalidOperationException 'region' contains an array formula or data table which extends outside the region.
The region of cells to apply the formula to.
Converts the formula to a string representation, similar to the string with which it was created. This uses the CellReferenceMode with which the formula was created to create cell reference strings.
The string representing the formula.
Converts the formula to a string representation, similar to the string with which it was created.
The string representing the formula.
The cell reference mode used to create cell reference strings.
Converts the formula to a string representation, similar to the string with which it was created.
The string representing the formula.
The cell reference mode used to create cell reference strings.
The culture used to generate the formula string.
Static
areDetermines whether two Formula instances are equal using the specified cell reference mode. This essentially performs a case-insensitive string comparison, ignoring the white space in the formula.
True if the formulas are both null or both equivalent; False otherwise.
The first Formula to compare.
The second Formula to compare.
The cell reference mode to use when comparing the two formulas.
Static
compareStatic
compareStatic
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
parseParses the specified formula value and returns the formula which was created from it.
ArgumentNullException 'value' is null or empty.
InvalidEnumArgumentException 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
FormulaParseException 'value' is not a valid formula.
A Formula instance which represents the formula specified.
The string which defines the formula to parse.
The mode used to interpret cell references in the formula.
Parses the specified formula value and returns the formula which was created from it.
ArgumentNullException 'value' is null or empty.
InvalidEnumArgumentException 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
InvalidEnumArgumentException 'fileFormat' is not defined in the WorkbookFormat enumeration.
FormulaParseException 'value' is not a valid formula.
A Formula instance which represents the formula specified.
The string which defines the formula to parse.
The mode used to interpret cell references in the formula.
The file format to use when parsing the formula. This will be used to determine certain limits which are format dependant.
Parses the specified formula value and returns the formula which was created from it.
ArgumentNullException 'value' is null or empty.
InvalidEnumArgumentException 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
InvalidEnumArgumentException 'fileFormat' is not defined in the WorkbookFormat enumeration.
FormulaParseException 'value' is not a valid formula.
A Formula instance which represents the formula specified.
The string which defines the formula to parse.
The mode used to interpret cell references in the formula.
The file format to use when parsing the formula. This will be used to determine certain limits which are format dependant.
The culture used to parse the formula.
Parses the specified formula value and returns the formula which was created from it.
ArgumentNullException 'value' is null or empty.
InvalidEnumArgumentException 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
FormulaParseException 'value' is not a valid formula.
A Formula instance which represents the formula specified.
The string which defines the formula to parse.
The mode used to interpret cell references in the formula.
The culture used to parse the formula.
Static
referenceStatic
static
Represents a formula for a cell or group of cells.
Formulas provide a way to show dynamic values in a cell. The value could be based any number of factors, such as the values of other cells and the time of day. Those alternate cells can even exist in different workbook files on the user's machine or on the internet.
See Microsoft Excel help for more information on formulas.
Use one of the Parse or TryParse overloads to create a new formula.