Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / DataOrientation Enumeration
Example Example


In This Topic
    DataOrientation Enumeration
    In This Topic
    Represents the orientation of the range.
    Syntax
    'Declaration
     
    Public Enum DataOrientation 
       Inherits System.Enum
    'Usage
     
    Dim instance As DataOrientation
    public enum DataOrientation : System.Enum 
    Members
    MemberDescription
    HorizontalSpecifies the horizontal orientation.
    VerticalSpecifies the vertical orientation.
    Example
    This example uses the DataOrientation 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.DataOrientation

    See Also