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.v21.1.Core.dll


public bool SummaryCountBlankCells { get; set; }

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