Spread for ASP.NET 9.0 Product Documentation
AddSquareSparkline Method
Example 


The data.
The location.
The type.
The setting.
if set to true [is column].
Adds the sparkline.
Syntax
'Declaration
 
Public Function AddSquareSparkline( _
   ByVal data As SheetCellRange, _
   ByVal location As CellRange, _
   ByVal type As SparklineType, _
   ByVal setting As ExcelSparklineSetting, _
   ByVal isColumn As Boolean _
) As ExcelSparklineGroup
'Usage
 
Dim instance As SheetView
Dim data As SheetCellRange
Dim location As CellRange
Dim type As SparklineType
Dim setting As ExcelSparklineSetting
Dim isColumn As Boolean
Dim value As ExcelSparklineGroup
 
value = instance.AddSquareSparkline(data, location, type, setting, isColumn)
public ExcelSparklineGroup AddSquareSparkline( 
   SheetCellRange data,
   CellRange location,
   SparklineType type,
   ExcelSparklineSetting setting,
   bool isColumn
)

Parameters

data
The data.
location
The location.
type
The type.
setting
The setting.
isColumn
if set to true [is column].
Example
This example creates a sparkline in a cell.
FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
fpSpread1.Sheets[0] = sv;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 10;
sv.Cells[4, 0].Value = 2;
sv.Cells[4, 1].Value = 1;
sv.Cells[5, 0].Value = 5;
sv.Cells[5, 1].Value = 3;
FarPoint.Web.Spread.Chart.SheetCellRange newdata = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 4, 0, 2, 2);
FarPoint.Web.Spread.Model.CellRange newlocation = new FarPoint.Web.Spread.Model.CellRange(6, 0, 1, 2);
FarPoint.Web.Spread.ExcelSparklineSetting ex2 = new FarPoint.Web.Spread.ExcelSparklineSetting();
fpSpread1.Sheets[0].AddSquareSparkline(newdata, newlocation, FarPoint.Web.Spread.SparklineType.Column, ex2, true);
Dim sv As New FarPoint.Web.Spread.SheetView()
FpSpread1.Sheets(0) = sv
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
sv.Cells(4, 0).Value = 2
sv.Cells(4, 1).Value = 1
sv.Cells(5, 0).Value = 5
sv.Cells(5, 1).Value = 3
Dim newdata = New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 4, 0, 2, 2)
Dim newlocation = New FarPoint.Web.Spread.Model.CellRange(6, 0, 1, 2)
Dim ex2 As New FarPoint.Web.Spread.ExcelSparklineSetting()
FpSpread1.Sheets(0).AddSquareSparkline(newdata, newlocation, FarPoint.Web.Spread.SparklineType.Column, ex2, True)
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetView Class
SheetView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.