FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : AddSquareSparkline Method |
true
[is column].
'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 )
true
[is column].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)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6