TXlsFile.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.XlsAdapter
procedure TXlsFile.SetWhatIfTable(const range: TXlsCellRange; const rowInputCell: TCellAddress; const colInputCell: TCellAddress); override;
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. |
See also