Spread WPF Documentation
DisplayEmptyCellsAs Property (SparklineSetting)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > SparklineSetting Class : DisplayEmptyCellsAs Property
Gets or sets how to display the empty cells.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property DisplayEmptyCellsAs As EmptyValueStyle
'Usage
 
Dim instance As SparklineSetting
Dim value As EmptyValueStyle
 
instance.DisplayEmptyCellsAs = value
 
value = instance.DisplayEmptyCellsAs
[System.ComponentModel.DefaultValue()]
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();
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()
See Also

Reference

SparklineSetting Class
SparklineSetting Members