XlsxExportOptionsEx.SummaryCountBlankCells Property

Gets or sets whether the Count summary function takes all cells into account or only non-blank cells when exporting to Excel format.Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

[XtraSerializableProperty]
public bool SummaryCountBlankCells { get; set; }

VB.NET

<XtraSerializableProperty>
Public Property SummaryCountBlankCells As Boolean

Property Value

Type	Description
Boolean	true, if non-blank and blank cells are counted; false if non-blank cells are only counted. The default value is false.

Remarks

The Count summary function in a source Grid/TreeList control calculates the number of data rows (regardless of whether row values are empty or not). By default, this function is represented in Excel format by a function that calculates the number of non-blank cells. To take into account blank and non-blank cells in the export document, set the SummaryCountBlankCells property to true.