Aspose::Cells::Cell::SetTableFormula method

Cell::SetTableFormula(int32_t, int32_t, const U16String&, const U16String&, const Vector <Vector <Aspose::Cells::Object>>&) method

Create two-variable data table for given range starting from this cell.

void Aspose::Cells::Cell::SetTableFormula(int32_t rowNumber, int32_t columnNumber, const U16String &rowInputCell, const U16String &columnInputCell, const Vector<Vector<Aspose::Cells::Object>> &values)

Parameter	Type	Description
rowNumber	int32_t	Number of rows to populate the formula.
columnNumber	int32_t	Number of columns to populate the formula.
rowInputCell	const U16String&	the row input cell
columnInputCell	const U16String&	the column input cell
values	const Vector <Vector <Aspose::Cells::Object>>&	values for cells in table formula range

See Also

• Class Vector
• Class U16String
• Class Object
• Class Cell
• Namespace Aspose::Cells
• Library Aspose.Cells for C++

Cell::SetTableFormula(int32_t, int32_t, const char16_t*, const char16_t*, const Vector <Vector <Aspose::Cells::Object>>&) method

Create two-variable data table for given range starting from this cell.

void Aspose::Cells::Cell::SetTableFormula(int32_t rowNumber, int32_t columnNumber, const char16_t *rowInputCell, const char16_t *columnInputCell, const Vector<Vector<Aspose::Cells::Object>> &values)

Parameter	Type	Description
rowNumber	int32_t	Number of rows to populate the formula.
columnNumber	int32_t	Number of columns to populate the formula.
rowInputCell	const char16_t*	the row input cell
columnInputCell	const char16_t*	the column input cell
values	const Vector <Vector <Aspose::Cells::Object>>&	values for cells in table formula range

See Also

• Class Vector
• Class Object
• Class Cell
• Namespace Aspose::Cells
• Library Aspose.Cells for C++

Cell::SetTableFormula(int32_t, int32_t, const U16String&, bool, const Vector <Vector <Aspose::Cells::Object>>&) method

Create one-variable data table for given range starting from this cell.

void Aspose::Cells::Cell::SetTableFormula(int32_t rowNumber, int32_t columnNumber, const U16String &inputCell, bool isRowInput, const Vector<Vector<Aspose::Cells::Object>> &values)

Parameter	Type	Description
rowNumber	int32_t	Number of rows to populate the formula.
columnNumber	int32_t	Number of columns to populate the formula.
inputCell	const U16String&	the input cell
isRowInput	bool	Indicates whether the input cell is a row input cell(true) or a column input cell(false).
values	const Vector <Vector <Aspose::Cells::Object>>&	values for cells in table formula range

See Also

• Class Vector
• Class U16String
• Class Object
• Class Cell
• Namespace Aspose::Cells
• Library Aspose.Cells for C++

Cell::SetTableFormula(int32_t, int32_t, const char16_t*, bool, const Vector <Vector <Aspose::Cells::Object>>&) method

Create one-variable data table for given range starting from this cell.

void Aspose::Cells::Cell::SetTableFormula(int32_t rowNumber, int32_t columnNumber, const char16_t *inputCell, bool isRowInput, const Vector<Vector<Aspose::Cells::Object>> &values)

Parameter	Type	Description
rowNumber	int32_t	Number of rows to populate the formula.
columnNumber	int32_t	Number of columns to populate the formula.
inputCell	const char16_t*	the input cell
isRowInput	bool	Indicates whether the input cell is a row input cell(true) or a column input cell(false).
values	const Vector <Vector <Aspose::Cells::Object>>&	values for cells in table formula range

See Also

• Class Vector
• Class Object
• Class Cell
• Namespace Aspose::Cells
• Library Aspose.Cells for C++

Cell::SetTableFormula(int32_t, int32_t, int32_t, int32_t, int32_t, int32_t, const Vector <Vector <Aspose::Cells::Object>>&) method

Create two-variable data table for given range starting from this cell.

void Aspose::Cells::Cell::SetTableFormula(int32_t rowNumber, int32_t columnNumber, int32_t rowIndexOfRowInputCell, int32_t columnIndexOfRowInputCell, int32_t rowIndexOfColumnInputCell, int32_t columnIndexOfColumnInputCell, const Vector<Vector<Aspose::Cells::Object>> &values)

Parameter	Type	Description
rowNumber	int32_t	Number of rows to populate the formula.
columnNumber	int32_t	Number of columns to populate the formula.
rowIndexOfRowInputCell	int32_t	row index of the row input cell
columnIndexOfRowInputCell	int32_t	column index of the row input cell
rowIndexOfColumnInputCell	int32_t	row index of the column input cell
columnIndexOfColumnInputCell	int32_t	column index of the column input cell
values	const Vector <Vector <Aspose::Cells::Object>>&	values for cells in table formula range

See Also

• Class Vector
• Class Object
• Class Cell
• Namespace Aspose::Cells
• Library Aspose.Cells for C++

Cell::SetTableFormula(int32_t, int32_t, int32_t, int32_t, bool, const Vector <Vector <Aspose::Cells::Object>>&) method

Create one-variable data table for given range starting from this cell.

void Aspose::Cells::Cell::SetTableFormula(int32_t rowNumber, int32_t columnNumber, int32_t rowIndexOfInputCell, int32_t columnIndexOfInputCell, bool isRowInput, const Vector<Vector<Aspose::Cells::Object>> &values)

Parameter	Type	Description
rowNumber	int32_t	Number of rows to populate the formula.
columnNumber	int32_t	Number of columns to populate the formula.
rowIndexOfInputCell	int32_t	row index of the input cell
columnIndexOfInputCell	int32_t	column index of the input cell
isRowInput	bool	Indicates whether the input cell is a row input cell(true) or a column input cell(false).
values	const Vector <Vector <Aspose::Cells::Object>>&	values for cells in table formula range

See Also

• Class Vector
• Class Object
• Class Cell
• Namespace Aspose::Cells
• Library Aspose.Cells for C++