ExcelFile.SetWhatIfTable Method
Creates an Excel What-if table in the range of cells specified by Range. Calling this method is the same as setting a cell value with a TFormula where TFormula.Span has more than one cell, and TFormula.Text is something like "{=TABLE(,A4)}". The parameters for the =TABLE function are rowInputCell and colInputCell, and they look the same a Excel will show them.
Syntax
Namespace: FlexCel.Core
public abstract void SetWhatIfTable(TXlsCellRange range, TCellAddress rowInputCell, TCellAddress colInputCell)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
range | TXlsCellRange | Range for the table. This is the range of cells that will have "={TABLE()}" formulas. | |
rowInputCell | TCellAddress | Row input cell for the table. Make it null if you don't want a row input cell. If both rowInputCell and colInputCell are null, a table with deleted references will be added. Note that the sheet here is ignored, What-if tables need the input cells to be in the same sheet as the table. |
|
colInputCell | TCellAddress | Column input cell for the table. Make it null if you don't want a column input cell. If both rowInputCell and colInputCell are null, a table with deleted references will be added. Note that the sheet here is ignored, What-if tables need the input cells to be in the same sheet as the table. |