Skip to main content

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

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

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.

See Also