IXlOutlineProperties.SummaryBelow Property

Gets or sets a value indicating whether the summary rows are located below detail rows

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

bool SummaryBelow { get; set; }

VB.NET

Property SummaryBelow As Boolean

Property Value

Type	Description
Boolean	true, if summary rows are below each group of detail rows; otherwise, false.

Remarks

Use the SummaryBelow property to specify the summary row location. For example, if summary rows are located above detail rows in each group, set the SummaryBelow 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.

SummaryBelow = true	SummaryBelow = false

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SummaryBelow property.

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#

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L128

// Specify the summary row and summary column location for the grouped data.
sheet.OutlineProperties.SummaryBelow = true;
sheet.OutlineProperties.SummaryRight = true;