TXlsFile.FreezePanes Method
This command is equivalent to Menu->Window->Freeze Panes. It will freeze the rows and columns above and to the left from cell. Note that because Excel works this way, when you TExcelFile.SplitWindow the panes are suppressed and vice-versa See also TExcelFile.GetFrozenPanes This property can work in different windows depending on the value of TExcelFile.ActiveWindow
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.FreezePanes(const cell: TCellAddress); override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | cell | TCellAddress | All rows and columns above and to the left of this cell will be frozen. Set it to null or "A1" to unfreeze the panes. |