Visual Basic (Declaration) | |
---|---|
Public Function AddSparklineToGroup( _ ByVal sparkline As ISparkline, _ ByVal sparklineGroup As ISparklineGroup _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As DefaultSparklineContainer Dim sparkline As ISparkline Dim sparklineGroup As ISparklineGroup Dim value As Boolean value = instance.AddSparklineToGroup(sparkline, sparklineGroup) |
C# | |
---|---|
public bool AddSparklineToGroup( ISparkline sparkline, ISparklineGroup sparklineGroup ) |
Parameters
- sparkline
- The sparkline.
- sparklineGroup
- The sparkline group information.
This example uses the AddSparklineToGroup method.
C# | Copy Code |
---|---|
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 | Copy Code |
---|---|
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2