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

Declaration

C#

public bool SuppressEmptyStrings { get; set; }

VB.NET

Public Property SuppressEmptyStrings As Boolean

Property Value

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

Remarks

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.