Worksheet.AutoOutline() Method

Automatically creates an outline for the specified worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void AutoOutline()

VB.NET

Sub AutoOutline

Example

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.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832

GroupAndOutlineActions.vb

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

GroupAndOutlineActions.cs

// Outline the data automatically based on the summary formulas.
worksheet.AutoOutline();

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AutoOutline() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/GroupAndOutlineActions.cs#L71

// Outline data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/GroupAndOutlineActions.cs#L110

// Outline the data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline

winforms-spreadsheetcontrol-api-part-2-e4832/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/GroupAndOutlineActions.cs#L110

// Outline the data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/GroupAndOutlineActions.vb#L68

            ' Outline data automatically based on the summary formulas.
            worksheet.AutoOutline()
'            #End Region ' #AutoOutline

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/GroupAndOutlineActions.vb#L102

                    ' Outline the data automatically based on the summary formulas.
                    worksheet.AutoOutline()
'                    #End Region ' #AutoOutline

winforms-spreadsheetcontrol-api-part-2-e4832/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/GroupAndOutlineActions.vb#L102

                    ' Outline the data automatically based on the summary formulas.
                    worksheet.AutoOutline()
'                    #End Region ' #AutoOutline