GetSparkline(Int32,Int32,ISparklineGroup,ISparkline) Method

Gets the sparkline in the specified location.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetSparkline( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByRef sparklineGroup As ISparklineGroup, _
   ByRef sparkline As ISparkline _
) As Boolean

'Usage
 
Dim instance As DefaultSparklineContainer
Dim row As Integer
Dim column As Integer
Dim sparklineGroup As ISparklineGroup
Dim sparkline As ISparkline
Dim value As Boolean
 
value = instance.GetSparkline(row, column, sparklineGroup, sparkline)

public bool GetSparkline( 
   int row,
   int column,
   out ISparklineGroup sparklineGroup,
   out ISparkline sparkline
)

Parameters

row: The row.
column: The column.
sparklineGroup: The sparkline group information in the specified location.
sparkline: The sparkline.

Return Value

true if the sparkline exists in the location.

Example

This example creates sparklines.

fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 10;
fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5");
FarPoint.Web.Spread.ExcelSparklineSetting eSetting = new FarPoint.Web.Spread.ExcelSparklineSetting();
eSetting.ShowMarkers = true;
eSetting.AxisColor = Color.Cyan;
FarPoint.Web.Spread.ExcelSparkline es = new FarPoint.Web.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(0, 0, 1, 5));
FarPoint.Web.Spread.ExcelSparklineSetting est = eSetting;
FarPoint.Web.Spread.ExcelSparklineGroup esg = new FarPoint.Web.Spread.ExcelSparklineGroup(est, FarPoint.Web.Spread.SparklineType.Column);
esg.Add(es);
fpSpread1.Sheets[0].SparklineContainer.Add(esg);
FarPoint.Web.Spread.ISparklineGroup outGroup;
FarPoint.Web.Spread.ISparkline outSL;
fpSpread1.Sheets[0].SparklineContainer.GetSparkline(1, 5, out outGroup, out outSL);

Visual Basic

FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
fpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" & vbTab & "2" & vbTab & "3" & vbTab & "4" & vbTab & "5")
Dim eSetting As New FarPoint.Web.Spread.ExcelSparklineSetting()
eSetting.ShowMarkers = True
eSetting.AxisColor = Color.Cyan
Dim es As New FarPoint.Web.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(0, 0, 1, 5))
Dim est As FarPoint.Web.Spread.ExcelSparklineSetting = eSetting
Dim esg As New FarPoint.Web.Spread.ExcelSparklineGroup(est, FarPoint.Web.Spread.SparklineType.Column)
esg.Add(es)
fpSpread1.Sheets(0).SparklineContainer.Add(esg)
Dim outGroup As FarPoint.Web.Spread.ISparklineGroup
Dim outSL As FarPoint.Web.Spread.ISparkline

fpSpread1.Sheets(0).SparklineContainer.GetSparkline(1, 5, outGroup, outSL)

Requirements

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

Reference

DefaultSparklineContainer Class
DefaultSparklineContainer Members
Overload List