XlSparklineGroup.DisplayBlanksAs Property

Gets or sets how empty cells are plotted.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlDisplayBlanksAs DisplayBlanksAs { get; set; }

VB.NET

Public Property DisplayBlanksAs As XlDisplayBlanksAs

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.