Spread WPF Documentation
EmptyValueStyle Enumeration
Example Example 


GrapeCity.Windows.SpreadSheet.Data Namespace : EmptyValueStyle Enumeration
Specifies how to show an empty value from a data series in the chart.
Syntax
'Declaration
 
Public Enum EmptyValueStyle 
   Inherits System.Enum
'Usage
 
Dim instance As EmptyValueStyle
public enum EmptyValueStyle : System.Enum 
Members
MemberDescription
ConnectFills gaps with a connecting element instead of leaving gaps for empty values in a data series.
GapsLeaves gaps for empty values in a data series, which results in a segmented line.
ZeroHandles empty values in a data series as zero values, so that the line drops to zero for zero-value data points.
Example
This example uses the EmptyValueStyle enumeration.
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()
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.EmptyValueStyle

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace