SparklineGroup.DisplayBlanksAs Property

Gets or sets a value that specifies how empty cells should be plotted on the sparklines in the current sparkline group.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

DisplayBlanksAs DisplayBlanksAs { get; set; }

VB.NET

Property DisplayBlanksAs As DisplayBlanksAs

Property Value

Type	Description
DisplayBlanksAs	A DisplayBlanksAs enumeration value that determines how blank values should be displayed on a sparkline.

Available values:

Name	Description
Zero	Specifies that empty cells should be treated as zeros.
Span	Specifies that empty cells should be spanned with a line.
Gap	Specifies that empty cells should be displayed as gaps on a chart.

Remarks

Use the DisplayBlanksAs property to determine the way empty cells are plotted on the sparklines.

The table below lists the possible ways to display blank values on a sparkline.

Show empty cells as	Example
Gaps	C# sparklineGroup.DisplayBlanksAs = DisplayBlanksAs.Gap;
Zero	C# sparklineGroup.DisplayBlanksAs = DisplayBlanksAs.Zero;
Connect data points with a line (for the line sparklines only)	C# sparklineGroup.DisplayBlanksAs = DisplayBlanksAs.Span;

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