TExcelFile.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
Unit: FlexCel.Core
procedure TExcelFile.SetWhatIfTable(const range: TXlsCellRange; const rowInputCell: TCellAddress; const colInputCell: TCellAddress); virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | range | TXlsCellRange | Range for the table. This is the range of cells that will have "={TABLE()}" formulas. |
| const | 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. |
| const | 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. |