The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Worksheet.AutoOutline() Method

Automatically creates an outline for the specified worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

void AutoOutline()
Sub AutoOutline
void AutoOutline()
Sub AutoOutline
void AutoOutline()
Sub AutoOutline

Examples

The example below demonstrates how to outline data automatically using the Worksheet.AutoOutline method.

The Worksheet.AutoOutline method uses worksheet formulas to determine how to group data. Thus, make sure that the worksheet you wish to outline contains summary rows or columns with formulas based on which the outline will be created. If you did not specify any summary formulas, the data will not be grouped.

To remove an outline for the specified worksheet, use the Worksheet.ClearOutline method.

' Outline the data automatically based on the summary formulas.
worksheet.AutoOutline()
See Also