Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / SparklineType Enumeration
Example Example


In This Topic
    SparklineType Enumeration
    In This Topic
    Represents the sparkline type.
    Syntax
    'Declaration
     
    Public Enum SparklineType 
       Inherits System.Enum
    'Usage
     
    Dim instance As SparklineType
    public enum SparklineType : System.Enum 
    Members
    MemberDescription
    ColumnSpecifies the column sparkline.
    LineSpecifies the line sparkline.
    WinlossSpecifies the winloss sparkline.
    Example
    This example uses the SparklineType enumeration.
    GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5);
    GrapeCity.Windows.SpreadSheet.Data.CellRange cellr2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 5);
    GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting();
    ex.AxisColor = System.Windows.SystemColors.ActiveBorderColor;
    ex.LineWeight = 1;
    ex.ShowMarkers = true;
    ex.MarkersColor = Color.FromRgb(255, 0, 128);
    ex.ShowFirst = true;
    ex.ShowHigh = true;
    //ex.ShowLow = true;
    ex.ShowLast = true;
    ex.ShowNegative = true;
    ex.FirstMarkerColor = Color.FromRgb(163, 73, 164);
    ex.HighMarkerColor = Color.FromRgb(49, 78, 111);
    ex.LastMarkerColor = Color.FromRgb(0, 255, 255);
    //ex.LowMarkerColor = Color.FromRgb(255, 255, 0);
    ex.NegativeColor = Color.FromRgb(255, 255, 0);
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2;
    gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 5;
    gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 4;
    gcSpreadSheet1.Sheets[0].Cells[0, 3].Value = -1;
    gcSpreadSheet1.Sheets[0].Cells[0, 4].Value = 3;
    gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = new DateTime(2011, 1, 11);
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = new DateTime(2011, 1, 08);
    gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = new DateTime(2011, 1, 09);
    gcSpreadSheet1.Sheets[0].Cells[1, 3].Value = new DateTime(2011, 1, 14);
    gcSpreadSheet1.Sheets[0].Cells[1, 4].Value = new DateTime(2011, 1, 20);
    gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex);
    //gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, cellr2, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, ex);
    gcSpreadSheet1.Invalidate();
    Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5)
    Dim cellr2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(1, 0, 1, 5)
    Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting()
    ex.AxisColor = System.Windows.SystemColors.ActiveBorderColor
    ex.LineWeight = 1
    ex.ShowMarkers = True
    ex.MarkersColor = Color.FromRgb(255, 0, 128)
    ex.ShowFirst = True
    ex.ShowHigh = True
    'ex.ShowLow = True
    ex.ShowLast = True
    ex.ShowNegative = True
    ex.FirstMarkerColor = Color.FromRgb(163, 73, 164)
    ex.HighMarkerColor = Color.FromRgb(49, 78, 111)
    ex.LastMarkerColor = Color.FromRgb(0, 255, 255)
    'ex.LowMarkerColor = Color.FromRgb(255, 255, 0)
    ex.NegativeColor = Color.FromRgb(255, 255, 0)
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2
    GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 5
    GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 4
    GcSpreadSheet1.Sheets(0).Cells(0, 3).Value = -1
    GcSpreadSheet1.Sheets(0).Cells(0, 4).Value = 3
    GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = new DateTime(2011, 1, 11)
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = new DateTime(2011, 1, 08)
    GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = new DateTime(2011, 1, 09)
    GcSpreadSheet1.Sheets(0).Cells(1, 3).Value = new DateTime(2011, 1, 14)
    GcSpreadSheet1.Sheets(0).Cells(1, 4).Value = new DateTime(2011, 1, 20)
    GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex)
    'GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, cellr2, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, ex)
    GcSpreadSheet1.Invalidate()
    Inheritance Hierarchy

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

    See Also