## 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.

```cpp
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](../../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.

```cpp
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.

```cpp
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](../../u16string/)
* Class [FormulaParseOptions](../../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.

```cpp
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](../../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.

```cpp
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](../../u16string/)
* Class [FormulaParseOptions](../../formulaparseoptions/)
* Class [Vector](../../vector/)
* Class [Object](../../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.

```cpp
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](../../formulaparseoptions/)
* Class [Vector](../../vector/)
* Class [Object](../../object/)
* Class [Cell](../)
* Namespace [Aspose::Cells](../../)
* Library [Aspose.Cells for C++](../../../)