ExcelFile.CollapseOutlineCols Method
Overloads
- ExcelFile.CollapseOutlineCols(Int32, TCollapseChildrenMode)
- ExcelFile.CollapseOutlineCols(Int32, TCollapseChildrenMode, Int32, Int32)
ExcelFile.CollapseOutlineCols(Int32, TCollapseChildrenMode)
Collapses or expands the column outlines in a sheet to the specified level. It is equivalent to pressing the numbers at the left of the outline gutter in Excel.
Syntax
Namespace: FlexCel.Core
public void CollapseOutlineCols(Int32 level, TCollapseChildrenMode collapseChildren)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
level | Int32 | Level that we want to display from the outline. (1 based). For example, setting Level = 3 is the same as pressing the "3" number at the left of the outline gutter in Excel. Setting Level = 1 will collapse all groups, Level = 8 will expand all groups. |
|
collapseChildren | TCollapseChildrenMode | Determines if the children of the collapsed nodes will be collapsed too. |
See also
ExcelFile.CollapseOutlineCols(Int32, TCollapseChildrenMode, Int32, Int32)
Collapses or expands the column 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
Namespace: FlexCel.Core
public abstract void CollapseOutlineCols(Int32 level, TCollapseChildrenMode collapseChildren, Int32 firstCol, Int32 lastCol)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
level | Int32 | Level that we want to display from the outline. (1 based). For example, setting Level = 3 is the same as pressing the "3" number at the left of the outline gutter in Excel. Setting Level = 1 will collapse all groups, Level = 8 will expand all groups. |
|
collapseChildren | TCollapseChildrenMode | Determines if the children of the collapsed nodes will be collapsed too. | |
firstCol | Int32 | This defines the first column of the range to collapse/expand. Only columns inside that range will be modified. | |
lastCol | Int32 | This defines the last column of the range to collapse/expand. Only columns inside that range will be modified. |