Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / EmptyValueStyle Enumeration
Example Example


In This Topic
    EmptyValueStyle Enumeration
    In This Topic
    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