Worksheet.CalculateArrayFormula
CalculateArrayFormula(string, CalculationOptions)
Calculates a formula as array formula.
public object[][] CalculateArrayFormula(string formula, CalculationOptions opts)
| Parameter | Type | Description |
|---|---|---|
| formula | String | Formula to be calculated. |
| opts | CalculationOptions | Options for calculating formula |
See Also
- class CalculationOptions
- class Worksheet
- namespace Aspose.Cells
- assembly Aspose.Cells
CalculateArrayFormula(string, CalculationOptions, int, int)
Calculates a formula as array formula.
public object[][] CalculateArrayFormula(string formula, CalculationOptions opts, int maxRowCount,
int maxColumnCount)
| Parameter | Type | Description |
|---|---|---|
| formula | String | Formula to be calculated. |
| opts | CalculationOptions | Options for calculating formula |
| maxRowCount | Int32 | the maximum row count of resultant data. If it is non-positive or greater than the actual row count, then actual row count will be used. |
| maxColumnCount | Int32 | the maximum column count of resultant data. If it is non-positive or greater than the actual row count, then actual column count will be used. |
Return Value
Calculated formula result.
Remarks
The formula will be taken as dynamic array formula to calculate the dimension and result. User specified maximum dimension is used for cases that the calculated result is large data set (for example, the calculated result may correspond to a whole row or column data) but user does not need so large an array according to business requirement or for performance consideration.
See Also
- class CalculationOptions
- class Worksheet
- namespace Aspose.Cells
- assembly Aspose.Cells
CalculateArrayFormula(string, FormulaParseOptions, CalculationOptions, int, int, int, int, CalculationData)
Calculates a formula as array formula.
public object[][] CalculateArrayFormula(string formula, FormulaParseOptions pOpts,
CalculationOptions cOpts, int baseCellRow, int baseCellColumn, int maxRowCount,
int maxColumnCount, CalculationData calculationData)
| Parameter | Type | Description |
|---|---|---|
| formula | String | Formula to be calculated. |
| pOpts | FormulaParseOptions | Options for parsing formula |
| cOpts | CalculationOptions | Options for calculating formula |
| baseCellRow | Int32 | The row index of the base cell. |
| baseCellColumn | Int32 | The column index of the base cell. |
| maxRowCount | Int32 | The maximum row count of resultant data. If it is non-positive or greater than the actual row count, then actual row count will be used. |
| maxColumnCount | Int32 | The maximum column count of resultant data. If it is non-positive or greater than the actual row count, then actual column count will be used. |
| calculationData | CalculationData | The calculation data. It is used for the situation that user needs to calculate some static formulas when implementing custom calculation engine. For such kind of situation, user needs to specify it with the calculation data provided for Calculate. |
Return Value
Calculated formula result.
Remarks
The formula will be taken as dynamic array formula to calculate the dimension and result. User specified maximum dimension is used for cases that the calculated result is large data set (for example, the calculated result may correspond to a whole row or column data) but user does not need so large an array according to business requirement or for performance consideration.
See Also
- class FormulaParseOptions
- class CalculationOptions
- class CalculationData
- class Worksheet
- namespace Aspose.Cells
- assembly Aspose.Cells