Spread WPF Documentation
LineWeight Property (SparklineSetting)
Example 


GrapeCity.Windows.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
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property LineWeight As System.Double
'Usage
 
Dim instance As SparklineSetting
Dim value As System.Double
 
instance.LineWeight = value
 
value = instance.LineWeight
[System.ComponentModel.DefaultValue()]
public System.double LineWeight {get; set;}
Example
This example sets the LineWeight property.
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()
See Also

Reference

SparklineSetting Class
SparklineSetting Members