XlsxExportOptionsEx.SuppressEmptyStrings Property

Gets or sets whether the source control cells with Empty Strings are exported as Blank cells in Excel format.Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

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


public bool SuppressEmptyStrings { get; set; }

Property Value

Type Description

true, to export the source control cells with Empty Strings as Blank cells; otherwise, false. The default is false.


By default, cells with Empty Strings exported from a source control to Excel format are not regarded as blank in MS Excel. If you call the ISBLANK function for these cells, the function’s result will be false.

If the SuppressEmptyStrings property is set to true, these cells will be regarded as blank by Excel, and the ISBLANK function will return true.

See Also