Spread for ASP.NET 11 Product Documentation
GetSparkline(Int32,Int32,ISparklineGroup,ISparkline) Method
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > DefaultSparklineContainer Class > GetSparkline Method : GetSparkline(Int32,Int32,ISparklineGroup,ISparkline) Method
The row.
The column.
The sparkline group information in the specified location.
The sparkline.
Gets the sparkline in the specified location.
Syntax
'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);
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)
See Also

Reference

DefaultSparklineContainer Class
DefaultSparklineContainer Members
Overload List