Table of Contents

XlsFile.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.XlsAdapter

public override 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.

See also