Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.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