Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ExcelSparklineSetting Class / LineWeight Property
Example


In This Topic
    LineWeight Property
    In This Topic
    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 a line weight value in the range of 0.0->3.0).
    Syntax
    'Declaration
     
    Public Property LineWeight As Double
    'Usage
     
    Dim instance As ExcelSparklineSetting
    Dim value As Double
     
    instance.LineWeight = value
     
    value = instance.LineWeight
    public double LineWeight {get; set;}
    Example
    This example creates a sparkline in a cell.
    FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
    FarPoint.Web.Spread.Chart.SheetCellRange data = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 0, 0, 1, 5);
    FarPoint.Web.Spread.Chart.SheetCellRange data2 = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 1, 1);
    
    FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting();
    ex.LineWeight = 2;
    ex.ShowMarkers = true;
    ex.DisplayXAxis = true;
    ex.DisplayHidden = true;
    fpSpread1.Sheets[0] = sv;
    fpSpread1.Sheets[0].RowCount = 10;
    fpSpread1.Sheets[0].ColumnCount = 10;
    sv.Cells[0, 0].Value = 2;
    sv.Cells[0, 1].Value = 5;
    sv.Cells[0, 2].Value = 4;
    sv.Cells[0, 3].Value = -1;
    sv.Cells[0, 4].Value = 3;
    sv.Columns[2].Visible = false;
    fpSpread1.Sheets[0].AddSparkline(data, data2, FarPoint.Web.Spread.SparklineType.Line, ex);
    Dim sv As New FarPoint.Web.Spread.SheetView()
    Dim data As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 0, 0, 1, 5)
    Dim data2 As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 1, 1)
    
    Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting()
    ex.LineWeight = 2
    ex.ShowMarkers = True
    ex.DisplayXAxis = True
    ex.DisplayHidden = True
    FpSpread1.Sheets(0) = sv
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 10
    sv.Cells(0, 0).Value = 2
    sv.Cells(0, 1).Value = 5
    sv.Cells(0, 2).Value = 4
    sv.Cells(0, 3).Value = -1
    sv.Cells(0, 4).Value = 3
    sv.Columns(2).Visible = False
    
    FpSpread1.Sheets(0).AddSparkline(data, data2, FarPoint.Web.Spread.SparklineType.Line, ex)
    See Also