Skip to main content

XlSparklineGroup.DisplayBlanksAs Property

Gets or sets how empty cells are plotted.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

public XlDisplayBlanksAs DisplayBlanksAs { get; set; }

Property Value

Type Description
XlDisplayBlanksAs

A XlDisplayBlanksAs enumeration member that specifies how blank values are displayed on a sparkline.

Available values:

Name Description
Zero

Empty cells are plotted as zero values.

Span

Empty cells are plotted as interpolated using a line which connects data points (for the Line type of a sparkline).

Gap

Empty cells are not plotted resulting in gaps on a chart.

Remarks

Note

To specify whether to show data in hidden rows and columns on a sparkline, use the XlSparklineGroup.DisplayHidden property.

See Also