LineWeight Property (SparklineSetting)

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

Visual Basic
C#

'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 uses 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.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();

VB.NET

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

Reference

SparklineSetting Class
SparklineSetting Members