Skip to main content
Row

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.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

DisplayBlanksAs DisplayBlanksAs { get; set; }

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

sparklineGroup.DisplayBlanksAs = DisplayBlanksAs.Gap;

SpreadsheetControl_Sparklines_DisplayBlanksAsGap

Zero

sparklineGroup.DisplayBlanksAs = DisplayBlanksAs.Zero;

SpreadsheetControl_Sparklines_DisplayBlanksAsZero

Connect data points with a line

(for the line sparklines only)

sparklineGroup.DisplayBlanksAs = DisplayBlanksAs.Span;

SpreadsheetControl_Sparklines_DisplayBlanksAsSpan

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

See Also