Skip to main content

IXlSheetViewOptions.ShowZeroValues Property

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

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

bool ShowZeroValues { get; set; }

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.

See Also