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


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)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

SparklineSetting Class
SparklineSetting Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options