Aspose::Cells::Cell::SetArrayFormula method
Contents
[
Hide
]Cell::SetArrayFormula(const U16String&, int32_t, int32_t) method
Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
void Aspose::Cells::Cell::SetArrayFormula(const U16String &arrayFormula, int32_t rowNumber, int32_t columnNumber)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | const U16String& | Array formula. |
| rowNumber | int32_t | Number of rows to populate result of the array formula. |
| columnNumber | int32_t | Number of columns to populate result of the array formula. |
See Also
- Class U16String
- Class Cell
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
Cell::SetArrayFormula(const char16_t*, int32_t, int32_t) method
Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
void Aspose::Cells::Cell::SetArrayFormula(const char16_t *arrayFormula, int32_t rowNumber, int32_t columnNumber)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | const char16_t* | Array formula. |
| rowNumber | int32_t | Number of rows to populate result of the array formula. |
| columnNumber | int32_t | Number of columns to populate result of the array formula. |
See Also
- Class Cell
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
Cell::SetArrayFormula(const U16String&, int32_t, int32_t, const FormulaParseOptions&) method
Sets an array formula to a range of cells.
void Aspose::Cells::Cell::SetArrayFormula(const U16String &arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions &options)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | const U16String& | Array formula. |
| rowNumber | int32_t | Number of rows to populate result of the array formula. |
| columnNumber | int32_t | Number of columns to populate result of the array formula. |
| options | const FormulaParseOptions& | Options for parsing the formula. |
See Also
- Class U16String
- Class FormulaParseOptions
- Class Cell
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
Cell::SetArrayFormula(const char16_t*, int32_t, int32_t, const FormulaParseOptions&) method
Sets an array formula to a range of cells.
void Aspose::Cells::Cell::SetArrayFormula(const char16_t *arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions &options)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | const char16_t* | Array formula. |
| rowNumber | int32_t | Number of rows to populate result of the array formula. |
| columnNumber | int32_t | Number of columns to populate result of the array formula. |
| options | const FormulaParseOptions& | Options for parsing the formula. |
See Also
- Class FormulaParseOptions
- Class Cell
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
Cell::SetArrayFormula(const U16String&, int32_t, int32_t, const FormulaParseOptions&, const Vector <Vector <Aspose::Cells::Object>>&) method
Sets an array formula to a range of cells.
void Aspose::Cells::Cell::SetArrayFormula(const U16String &arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions &options, const Vector<Vector<Aspose::Cells::Object>> &values)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | const U16String& | Array formula. |
| rowNumber | int32_t | Number of rows to populate result of the array formula. |
| columnNumber | int32_t | Number of columns to populate result of the array formula. |
| options | const FormulaParseOptions& | Options for parsing the formula. |
| values | const Vector <Vector <Aspose::Cells::Object>>& | values for those cells with given array formula |
See Also
- Class U16String
- Class FormulaParseOptions
- Class Vector
- Class Object
- Class Cell
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
Cell::SetArrayFormula(const char16_t*, int32_t, int32_t, const FormulaParseOptions&, const Vector <Vector <Aspose::Cells::Object>>&) method
Sets an array formula to a range of cells.
void Aspose::Cells::Cell::SetArrayFormula(const char16_t *arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions &options, const Vector<Vector<Aspose::Cells::Object>> &values)
| Parameter | Type | Description |
|---|---|---|
| arrayFormula | const char16_t* | Array formula. |
| rowNumber | int32_t | Number of rows to populate result of the array formula. |
| columnNumber | int32_t | Number of columns to populate result of the array formula. |
| options | const FormulaParseOptions& | Options for parsing the formula. |
| values | const Vector <Vector <Aspose::Cells::Object>>& | values for those cells with given array formula |
See Also
- Class FormulaParseOptions
- Class Vector
- Class Object
- Class Cell
- Namespace Aspose::Cells
- Library Aspose.Cells for C++