GrapeCity.Xaml.SpreadSheet.Data
LineWeight Property (SparklineSetting)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > SparklineSetting Class : LineWeight Property
Gets or sets a value that specifies the line weight for each sparkline in the sparkline group, where the line weight is measured in points. The weight must be greater than or equal to zero, and must be less than or equal to 3 (LineSeries only supports line weight values in the range of 0.0->3.0).
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property LineWeight As Double
'Usage
 
Dim instance As SparklineSetting
Dim value As Double
 
instance.LineWeight = value
 
value = instance.LineWeight
[DefaultValue()]
public double LineWeight {get; set;}
Example
This example sets the LineWeight property.
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)
See Also

Reference

SparklineSetting Class
SparklineSetting Members