officefileapi-devexpress-dot-spreadsheet-dot-worksheetoutlineoptions.md
Gets or sets a value indicating whether the summary rows are located below detail rows.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool SummaryRowsBelow { get; set; }
Property SummaryRowsBelow As Boolean
| Type | Description |
|---|---|
| Boolean |
true , if summary rows are below each group of detail rows; otherwise, false.
|
You can access this nested property as listed below:
| Object Type | Path to SummaryRowsBelow |
|---|---|
| Worksheet |
.OutlineOptions .SummaryRowsBelow
|
Use the SummaryRowsBelow property to specify the summary row location. For example, if you inserted summary rows above detail rows in each group, set the SummaryRowsBelow property to false.
In this case, the grouping bar changes direction, so that the minus outline symbol is displayed opposite the summary row at the top of the group.
| SummaryRowsBelow = true | SummaryRowsBelow = false |
|---|---|
See Also
Group Data in the Spreadsheet Control
WorksheetOutlineOptions Interface