GrapeCity.Xaml.SpreadSheet.Data
SparklineType Enumeration
Example Example 


Represents the sparkline type.
Syntax
'Declaration
 
Public Enum SparklineType 
   Inherits System.Enum
'Usage
 
Dim instance As SparklineType
public enum SparklineType : System.Enum 
Members
MemberDescription
Column Specifies the column sparkline.
Line Specifies the line sparkline.
Winloss Specifies the winloss sparkline.
Example
This example uses the SparklineType enumeration.
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 1, 5);
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr2 = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 5);
GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting();
ex.AxisColor = Windows.UI.Colors.Azure;
ex.LineWeight = 1;
ex.ShowMarkers = true;
ex.MarkersColor = Windows.UI.Colors.CadetBlue;
ex.ShowFirst = true;
ex.ShowHigh = true;
//ex.ShowLow = true;
ex.ShowLast = true;
ex.ShowNegative = true;
ex.FirstMarkerColor = Windows.UI.Colors.Crimson;
ex.HighMarkerColor = Windows.UI.Colors.DarkGoldenrod;
ex.LastMarkerColor = Windows.UI.Colors.DarkGreen;
//ex.LowMarkerColor = Windows.UI.Colors.DarkOrange;
ex.NegativeColor = Windows.UI.Colors.GreenYellow;
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.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Line, ex);
//gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, cellr2, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, ex);
Dim cellr As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 1, 5)
Dim cellr2 As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 5)
Dim ex As New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting()
ex.AxisColor = Windows.UI.Colors.Azure
ex.LineWeight = 1
ex.ShowMarkers = True
ex.MarkersColor = Windows.UI.Colors.CadetBlue
ex.ShowFirst = True
ex.ShowHigh = True
'ex.ShowLow = True
ex.ShowLast = True
ex.ShowNegative = True
ex.FirstMarkerColor = Windows.UI.Colors.Crimson
ex.HighMarkerColor = Windows.UI.Colors.DarkGoldenrod
ex.LastMarkerColor = Windows.UI.Colors.DarkGreen
'ex.LowMarkerColor =  Windows.UI.Colors.DarkOrange
ex.NegativeColor = Windows.UI.Colors.GreenYellow
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, 8)
gcSpreadSheet1.Sheets(0).Cells(1, 2).Value = New DateTime(2011, 1, 9)
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.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Line, ex)
'GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, cellr2, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, ex)
Inheritance Hierarchy

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

Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options