Represents a formula for a cell or group of cells.
Inheritance
object
Classes that extend this class.
Derived ClassesMethods
Section titled "Methods"ApplyTo(WorksheetCell)
Section titled "ApplyTo(WorksheetCell)"Applies the formula to the specified cell.
public void ApplyTo(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
ApplyTo(WorksheetRegion)
Section titled "ApplyTo(WorksheetRegion)"Applies the formula to the specified region of cells.
public void ApplyTo(WorksheetRegion region)Parameters
- region:
WorksheetRegion
Returns any
ApplyTo(WorksheetRegion[])
Section titled "ApplyTo(WorksheetRegion[])"Applies the formula to all specified regions of cells.
public void ApplyTo(WorksheetRegion[] regions)Parameters
- regions:
WorksheetRegion[]
Returns any
Equals(Formula, Formula, CellReferenceMode)
Section titled "Equals(Formula, Formula, CellReferenceMode)"Determines whether two instances are equal using the specified cell reference mode.
public static bool Equals(Formula formulaA, Formula formulaB, CellReferenceMode cellReferenceMode)Parameters
- formulaA:
Formula - formulaB:
Formula - cellReferenceMode:
CellReferenceMode
Returns any
Parse(string, CellReferenceMode)
Section titled "Parse(string, CellReferenceMode)"Parses the specified formula value and returns the formula which was created from it.
public static Formula Parse(string value, CellReferenceMode cellReferenceMode)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode
Returns any
Parse(string, CellReferenceMode, WorkbookFormat)
Section titled "Parse(string, CellReferenceMode, WorkbookFormat)"Parses the specified formula value and returns the formula which was created from it.
public static Formula Parse(string value, CellReferenceMode cellReferenceMode, WorkbookFormat fileFormat)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat
Returns any
Parse(string, CellReferenceMode, WorkbookFormat, CultureInfo)
Section titled "Parse(string, CellReferenceMode, WorkbookFormat, CultureInfo)"Parses the specified formula value and returns the formula which was created from it.
public static Formula Parse(string value, CellReferenceMode cellReferenceMode, WorkbookFormat fileFormat, CultureInfo culture)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - culture:
CultureInfo
Returns any
Parse(string, CellReferenceMode, CultureInfo)
Section titled "Parse(string, CellReferenceMode, CultureInfo)"Parses the specified formula value and returns the formula which was created from it.
public static Formula Parse(string value, CellReferenceMode cellReferenceMode, CultureInfo culture)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo
Returns any
ToString()
Section titled "ToString()"Converts the formula to a string representation, similar to the string with which it was created. This uses the with which the formula was created to create cell reference strings.
public override string ToString()Returns any
ToString(CellReferenceMode)
Section titled "ToString(CellReferenceMode)"Converts the formula to a string representation, similar to the string with which it was created.
public string ToString(CellReferenceMode cellReferenceMode)Parameters
- cellReferenceMode:
CellReferenceMode
Returns any
ToString(CellReferenceMode, CultureInfo)
Section titled "ToString(CellReferenceMode, CultureInfo)"Converts the formula to a string representation, similar to the string with which it was created.
public string ToString(CellReferenceMode cellReferenceMode, CultureInfo culture)Parameters
- cellReferenceMode:
CellReferenceMode - culture:
CultureInfo
Returns any
TryParse(string, CellReferenceMode, out Formula)
Section titled "TryParse(string, CellReferenceMode, out Formula)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, out Formula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - formula:
Formula
Returns any
TryParse(string, CellReferenceMode, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, out Formula, out FormulaParseException)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, out Formula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - formula:
Formula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, out Formula)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, out Formula)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, WorkbookFormat fileFormat, out Formula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - formula:
Formula
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, out Formula, out FormulaParseException)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, WorkbookFormat fileFormat, out Formula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - formula:
Formula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out Formula)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out Formula)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, WorkbookFormat fileFormat, CultureInfo culture, out Formula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - culture:
CultureInfo - formula:
Formula
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out Formula, out FormulaParseException)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, WorkbookFormat fileFormat, CultureInfo culture, out Formula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - culture:
CultureInfo - formula:
Formula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, CultureInfo, out Formula)
Section titled "TryParse(string, CellReferenceMode, CultureInfo, out Formula)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, CultureInfo culture, out Formula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo - formula:
Formula
Returns any
TryParse(string, CellReferenceMode, CultureInfo, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, CultureInfo, out Formula, out FormulaParseException)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, CultureInfo culture, out Formula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo - formula:
Formula - exception:
FormulaParseException