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.v25.2.Core.dll

NuGet Package : DevExpress.Printing.Core

csharp

public bool SummaryCountBlankCells { get; set; }

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.