A newer version of this page is available. Switch to the current version.

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


public bool SummaryCountBlankCells { get; set; }
Public Property SummaryCountBlankCells As Boolean

Property Value

Type Description

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


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.


See Also