IXlSheetViewOptions.ShowZeroValues Property

Gets or sets whether to display zero values in worksheet cells.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

C#

bool ShowZeroValues { get; set; }

VB.NET

Property ShowZeroValues As Boolean

Property Value

Type	Description
Boolean	true, to display zero values; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowZeroValues
IXlSheet	.ViewOptions .ShowZeroValues

Remarks

By default, the ShowZeroValues property is true and the symbol 0 is displayed in cells that contain zero values. To display zero values as blank cells, set the ShowZeroValues to false. Note that this property does not affect the actual cell value, only the way it is displayed and printed.