Cell.SetTableFormula
Contents
[
Hide
]SetTableFormula(int, int, string, string, object[][])
Create two-variable data table for given range starting from this cell.
public void SetTableFormula(int rowNumber, int columnNumber, string rowInputCell,
string columnInputCell, object[][] values)
| Parameter | Type | Description |
|---|---|---|
| rowNumber | Int32 | Number of rows to populate the formula. |
| columnNumber | Int32 | Number of columns to populate the formula. |
| rowInputCell | String | the row input cell |
| columnInputCell | String | the column input cell |
| values | Object[][] | values for cells in table formula range |
See Also
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
SetTableFormula(int, int, string, bool, object[][])
Create one-variable data table for given range starting from this cell.
public void SetTableFormula(int rowNumber, int columnNumber, string inputCell, bool isRowInput,
object[][] values)
| Parameter | Type | Description |
|---|---|---|
| rowNumber | Int32 | Number of rows to populate the formula. |
| columnNumber | Int32 | Number of columns to populate the formula. |
| inputCell | String | the input cell |
| isRowInput | Boolean | Indicates whether the input cell is a row input cell(true) or a column input cell(false). |
| values | Object[][] | values for cells in table formula range |
See Also
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
SetTableFormula(int, int, int, int, int, int, object[][])
Create two-variable data table for given range starting from this cell.
public void SetTableFormula(int rowNumber, int columnNumber, int rowIndexOfRowInputCell,
int columnIndexOfRowInputCell, int rowIndexOfColumnInputCell, int columnIndexOfColumnInputCell,
object[][] values)
| Parameter | Type | Description |
|---|---|---|
| rowNumber | Int32 | Number of rows to populate the formula. |
| columnNumber | Int32 | Number of columns to populate the formula. |
| rowIndexOfRowInputCell | Int32 | row index of the row input cell |
| columnIndexOfRowInputCell | Int32 | column index of the row input cell |
| rowIndexOfColumnInputCell | Int32 | row index of the column input cell |
| columnIndexOfColumnInputCell | Int32 | column index of the column input cell |
| values | Object[][] | values for cells in table formula range |
See Also
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells
SetTableFormula(int, int, int, int, bool, object[][])
Create one-variable data table for given range starting from this cell.
public void SetTableFormula(int rowNumber, int columnNumber, int rowIndexOfInputCell,
int columnIndexOfInputCell, bool isRowInput, object[][] values)
| Parameter | Type | Description |
|---|---|---|
| rowNumber | Int32 | Number of rows to populate the formula. |
| columnNumber | Int32 | Number of columns to populate the formula. |
| rowIndexOfInputCell | Int32 | row index of the input cell |
| columnIndexOfInputCell | Int32 | column index of the input cell |
| isRowInput | Boolean | Indicates whether the input cell is a row input cell(true) or a column input cell(false). |
| values | Object[][] | values for cells in table formula range |
See Also
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells