DisplayEmptyCellsAs Property (SparklineSetting)

In This Topic

Gets or sets how to display the empty cells.

Syntax

Visual Basic
C#

'Declaration
 
<DefaultValueAttribute(Mono.Cecil.CustomAttributeArgument)>
Public Property DisplayEmptyCellsAs As EmptyValueStyle

'Usage
 
Dim instance As SparklineSetting
Dim value As EmptyValueStyle
 
instance.DisplayEmptyCellsAs = value
 
value = instance.DisplayEmptyCellsAs

[DefaultValue(Mono.Cecil.CustomAttributeArgument)]
public EmptyValueStyle DisplayEmptyCellsAs {get; set;}

Property Value

The display empty cells as value.

Example

This example uses the DisplayEmptyCellsAs property.

GrapeCity.Windows.SpreadSheet.Data.CellRange cellr2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 4);
GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting();
ex.DisplayEmptyCellsAs = GrapeCity.Windows.SpreadSheet.Data.EmptyValueStyle.Zero;
ex.DisplayXAxis = true;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 5;
gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 3;
gcSpreadSheet1.Sheets[0].Cells[1, 3].Value = 4;
gcSpreadSheet1.Sheets[0].SetSparkline(1, 5, cellr2, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex);
gcSpreadSheet1.Invalidate();

VB.NET

Dim cellr2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 4)
Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting()
ex.DisplayEmptyCellsAs = GrapeCity.Windows.SpreadSheet.Data.EmptyValueStyle.Zero
ex.DisplayXAxis = True
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 5
GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 3
GcSpreadSheet1.Sheets(0).Cells(1, 3).Value = 4
GcSpreadSheet1.Sheets(0).SetSparkline(1, 5, cellr2, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex)
GcSpreadSheet1.Invalidate()

Reference

SparklineSetting Class
SparklineSetting Members

Product Support Forum | Print this page