Cell.SetArrayFormula
Contents
[
Hide
]SetArrayFormula(string, int, int, bool, bool)
Sets an array formula to a range of cells.
[Obsolete("Use FormulaParseOptions for more options instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber, bool isR1C1,
bool isLocal)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | String | Array formula. |
| rowNumber | Int32 | Number of rows to populate result of the array formula. |
| columnNumber | Int32 | Number of columns to populate result of the array formula. |
| isR1C1 | Boolean | whether the formula is R1C1 formula |
| isLocal | Boolean | whether the formula is locale formatted |
Remarks
NOTE: This class is now obsolete. Instead, please use Cell.SetArrayFormula(string,int,int,FormulaParseOptions). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
See Also
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
SetArrayFormula(string, int, int)
Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | String | Array formula. |
| rowNumber | Int32 | Number of rows to populate result of the array formula. |
| columnNumber | Int32 | Number of columns to populate result of the array formula. |
See Also
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
SetArrayFormula(string, int, int, FormulaParseOptions)
Sets an array formula to a range of cells.
public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber,
FormulaParseOptions options)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | String | Array formula. |
| rowNumber | Int32 | Number of rows to populate result of the array formula. |
| columnNumber | Int32 | Number of columns to populate result of the array formula. |
| options | FormulaParseOptions | Options for parsing the formula. |
See Also
- class FormulaParseOptions
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
SetArrayFormula(string, int, int, FormulaParseOptions, object[][])
Sets an array formula to a range of cells.
public void SetArrayFormula(string arrayFormula, int rowNumber, int columnNumber,
FormulaParseOptions options, object[][] values)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | String | Array formula. |
| rowNumber | Int32 | Number of rows to populate result of the array formula. |
| columnNumber | Int32 | Number of columns to populate result of the array formula. |
| options | FormulaParseOptions | Options for parsing the formula. |
| values | Object[][] | values for those cells with given array formula |
See Also
- class FormulaParseOptions
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
