officefileapi-devexpress-dot-spreadsheet-dot-worksheet-3e3b0c25.md
Automatically creates an outline for the specified worksheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void AutoOutline()
Sub AutoOutline
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();
' Outline the data automatically based on the summary formulas.
worksheet.AutoOutline()
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.
// Outline the data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline
// Outline the data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline
// Outline data automatically based on the summary formulas.
worksheet.AutoOutline();
#endregion #AutoOutline
' Outline the data automatically based on the summary formulas.
worksheet.AutoOutline()
' #End Region ' #AutoOutline
' Outline the data automatically based on the summary formulas.
worksheet.AutoOutline()
' #End Region ' #AutoOutline
' Outline data automatically based on the summary formulas.
worksheet.AutoOutline()
' #End Region ' #AutoOutline
See Also