AddSparklineToGroup Method (DefaultSparklineContainer)

Visual Basic
C#

'Declaration
 
Public Function AddSparklineToGroup( _
   ByVal sparkline As ISparkline, _
   ByVal sparklineGroup As ISparklineGroup _
) As Boolean

'Usage
 
Dim instance As DefaultSparklineContainer
Dim sparkline As ISparkline
Dim sparklineGroup As ISparklineGroup
Dim value As Boolean
 
value = instance.AddSparklineToGroup(sparkline, sparklineGroup)

public bool AddSparklineToGroup( 
   ISparkline sparkline,
   ISparklineGroup sparklineGroup
)

Parameters

sparkline: The sparkline.
sparklineGroup: The sparkline group information.

This example uses the AddSparklineToGroup method.

C#

fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5");
FarPoint.Win.Spread.ExcelSparkline es = new FarPoint.Win.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets[0], new FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 5));
FarPoint.Win.Spread.ExcelSparklineGroup esg = new FarPoint.Win.Spread.ExcelSparklineGroup(new FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column);
esg.Add(es);
fpSpread1.Sheets[0].SparklineContainer.Add(esg);
fpSpread1.Sheets[0].SetClip(1, 0, 1, 5, "1\t2\t3\t4\t5");
FarPoint.Win.Spread.ExcelSparkline addES = new FarPoint.Win.Spread.ExcelSparkline(1, 5, fpSpread1.Sheets[0], new FarPoint.Win.Spread.Model.CellRange(1, 0, 1, 5));

fpSpread1.Sheets[0].SparklineContainer.AddSparklineToGroup(addES, fpSpread1.Sheets[0].SparklineContainer[0]);

Visual Basic

fpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" & vbTab & "2" & vbTab & "3" & vbTab & "4" & vbTab & "5")
Dim es As New FarPoint.Win.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets(0), New FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 5))
Dim esg As New FarPoint.Win.Spread.ExcelSparklineGroup(New FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column)
esg.Add(es)
fpSpread1.Sheets(0).SparklineContainer.Add(esg)
fpSpread1.Sheets(0).SetClip(1, 0, 1, 5, "1" & vbTab & "2" & vbTab & "3" & vbTab & "4" & vbTab & "5")
Dim addES As New FarPoint.Win.Spread.ExcelSparkline(1, 5, fpSpread1.Sheets(0), New FarPoint.Win.Spread.Model.CellRange(1, 0, 1, 5))

fpSpread1.Sheets(0).SparklineContainer.AddSparklineToGroup(addES, fpSpread1.Sheets(0).SparklineContainer(0))

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

DefaultSparklineContainer Class
DefaultSparklineContainer Members