'Declaration Public Enum DataOrientation Inherits System.Enum
'Usage Dim instance As DataOrientation
public enum DataOrientation : System.Enum
'Declaration Public Enum DataOrientation Inherits System.Enum
'Usage Dim instance As DataOrientation
public enum DataOrientation : System.Enum
Member | Description |
---|---|
Horizontal | Specifies the horizontal orientation. |
Vertical | Specifies the vertical orientation. |
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()
System.Object
System.ValueType
System.Enum
GrapeCity.Windows.SpreadSheet.Data.DataOrientation