GrapeCity.Windows.SpreadSheet.Data Namespace : SparklineType Enumeration |
'Declaration Public Enum SparklineType Inherits System.Enum
'Usage Dim instance As SparklineType
public enum SparklineType : System.Enum
Member | Description |
---|---|
Column | Specifies the column sparkline. |
Line | Specifies the line sparkline. |
Winloss | Specifies the winloss sparkline. |
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.FromArgb(255, 255, 0, 128); ex.ShowFirst = true; ex.ShowHigh = true; //ex.ShowLow = true; ex.ShowLast = true; ex.ShowNegative = true; ex.FirstMarkerColor = Color.FromArgb(255, 163, 73, 164); ex.HighMarkerColor = Color.FromArgb(255, 49, 78, 111); ex.LastMarkerColor = Color.FromArgb(255, 0, 255, 255); //ex.LowMarkerColor = Color.FromArgb(255, 255, 255, 0); ex.NegativeColor = Color.FromArgb(255, 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.FromArgb(255, 255, 0, 128) ex.ShowFirst = True ex.ShowHigh = True 'ex.ShowLow = True ex.ShowLast = True ex.ShowNegative = True ex.FirstMarkerColor = Color.FromArgb(255, 163, 73, 164) ex.HighMarkerColor = Color.FromArgb(255, 49, 78, 111) ex.LastMarkerColor = Color.FromArgb(255, 0, 255, 255) 'ex.LowMarkerColor = Color.FromArgb(255, 255, 255, 0) ex.NegativeColor = Color.FromArgb(255, 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.SparklineType
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6