Represents an array formula for a group of cells.
Inheritance
object
Properties
Section titled "Properties"CellRange
Section titled "CellRange"Gets the cells to which the array formula is applied.
public WorksheetRegion CellRange { get; }Methods
Section titled "Methods"ToString()
Section titled "ToString()"Inherited from: Formula
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
ApplyTo(WorksheetCell)
Section titled "ApplyTo(WorksheetCell)"Inherited from: Formula
Applies the formula to the specified cell.
public void ApplyTo(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
ApplyTo(WorksheetRegion)
Section titled "ApplyTo(WorksheetRegion)"Inherited from: Formula
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[])"Inherited from: Formula
Applies the formula to all specified regions of cells.
public void ApplyTo(WorksheetRegion[] regions)Parameters
- regions:
WorksheetRegion[]
Returns any
ToString(CellReferenceMode)
Section titled "ToString(CellReferenceMode)"Inherited from: Formula
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)"Inherited from: Formula
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
Equals(Formula, Formula, CellReferenceMode)
Section titled "Equals(Formula, Formula, CellReferenceMode)"Inherited from: Formula
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
TryParse(string, CellReferenceMode, out Formula)
Section titled "TryParse(string, CellReferenceMode, out Formula)"Inherited from: 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, CultureInfo, out Formula)
Section titled "TryParse(string, CellReferenceMode, CultureInfo, out Formula)"Inherited from: 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, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, out Formula, out FormulaParseException)"Inherited from: 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, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - formula:
Formula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, CultureInfo, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, CultureInfo, out Formula, out FormulaParseException)"Inherited from: 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, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo - formula:
Formula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, out Formula)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, out Formula)"Inherited from: 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, CultureInfo, out Formula)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out Formula)"Inherited from: 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, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, out Formula, out FormulaParseException)"Inherited from: 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, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - formula:
Formula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out Formula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out Formula, out FormulaParseException)"Inherited from: 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, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - culture:
CultureInfo - formula:
Formula - exception:
FormulaParseException
Returns any
ClearCellRange()
Section titled "ClearCellRange()"Removes this array formula as the formula for the cells to which it was applied.
public void ClearCellRange()Returns any
Parse(string, CellReferenceMode)
Section titled "Parse(string, CellReferenceMode)"Parses the specified formula value and returns the array formula which was created from it.
public static ArrayFormula 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 array formula which was created from it.
public static ArrayFormula 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 array formula which was created from it.
public static ArrayFormula 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 array formula which was created from it.
public static ArrayFormula Parse(string value, CellReferenceMode cellReferenceMode, CultureInfo culture)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo
Returns any
TryParse(string, CellReferenceMode, out ArrayFormula)
Section titled "TryParse(string, CellReferenceMode, out ArrayFormula)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, out ArrayFormula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - formula:
ArrayFormula
Returns any
TryParse(string, CellReferenceMode, out ArrayFormula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, out ArrayFormula, out FormulaParseException)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, out ArrayFormula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - formula:
ArrayFormula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, out ArrayFormula)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, out ArrayFormula)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, WorkbookFormat fileFormat, out ArrayFormula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - formula:
ArrayFormula
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, out ArrayFormula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, out ArrayFormula, 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 ArrayFormula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - formula:
ArrayFormula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out ArrayFormula)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out ArrayFormula)"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 ArrayFormula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - culture:
CultureInfo - formula:
ArrayFormula
Returns any
TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out ArrayFormula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, WorkbookFormat, CultureInfo, out ArrayFormula, 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 ArrayFormula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - fileFormat:
WorkbookFormat - culture:
CultureInfo - formula:
ArrayFormula - exception:
FormulaParseException
Returns any
TryParse(string, CellReferenceMode, CultureInfo, out ArrayFormula)
Section titled "TryParse(string, CellReferenceMode, CultureInfo, out ArrayFormula)"Parses the specified formula value. The return value indicates whether the operation succeeded.
public static bool TryParse(string value, CellReferenceMode cellReferenceMode, CultureInfo culture, out ArrayFormula formula)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo - formula:
ArrayFormula
Returns any
TryParse(string, CellReferenceMode, CultureInfo, out ArrayFormula, out FormulaParseException)
Section titled "TryParse(string, CellReferenceMode, CultureInfo, out ArrayFormula, 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 ArrayFormula formula, out FormulaParseException exception)Parameters
- value:
string - cellReferenceMode:
CellReferenceMode - culture:
CultureInfo - formula:
ArrayFormula - exception:
FormulaParseException