TExcelFile.CollapseOutlineRows Method

Overloads

TExcelFile.CollapseOutlineRows(Integer, TCollapseChildrenMode)

Collapses or expands the row outlines in a sheet to the specified level. It is equivalent to pressing the numbers at the top of the outline gutter in Excel.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.CollapseOutlineRows(const level: Integer; const collapseChildren: TCollapseChildrenMode); overload;

Parameters

<-> Parameter Type Description
const level Integer Level that we want to show of the outline. (1 based).
For example, setting Level = 3 is the same as pressing the "3" number at the top of the outline gutter in Excel.
Setting Level = 1 will collapse all groups, Level = 8 will expand all groups.
const collapseChildren TCollapseChildren​Mode Determines if the children of the collapsed nodes will be collapsed too.

See also

TExcelFile.CollapseOutlineRows(Integer, TCollapseChildrenMode, Integer, Integer)

Collapses or expands the row outlines in a sheet to the specified level. It is equivalent to pressing the numbers at the top of the outline gutter in Excel.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.CollapseOutlineRows(const level: Integer; const collapseChildren: TCollapseChildrenMode; const firstRow: Integer; const lastRow: Integer); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const level Integer Level that we want to show of the outline. (1 based).
For example, setting Level = 3 is the same as pressing the "3" number at the top of the outline gutter in Excel.
Setting Level = 1 will collapse all groups, Level = 8 will expand all groups.
const collapseChildren TCollapseChildren​Mode Determines if the children of the collapsed nodes will be collapsed too.
const firstRow Integer This defines the first row of the range to collapse/expand. Only rows inside that range will be modified.
const lastRow Integer This defines the last row of the range to collapse/expand. Only rows inside that range will be modified.

See also