UngroupSparkline Method

Visual Basic
C#

'Declaration
 
Public Sub UngroupSparkline( _
   ByVal group As SparklineGroup _
)

'Usage
 
Dim instance As Worksheet
Dim group As SparklineGroup
 
instance.UngroupSparkline(group)

public void UngroupSparkline( 
   SparklineGroup group
)

Parameters

group: The group.

This example uses the UngroupSparkline method.

C#
VB.NET

for (int i = 0; i < 2; i++)
            {
                for (int j = 1; j < 5; j++)
                {
                    this.gcSpreadSheet1.Sheets[0].Cells[i, j].Value = i * 10 + j;
                }
            }

            GrapeCity.Xaml.SpreadSheet.Data.Sparkline sparkline1 = gcSpreadSheet1.Sheets[0].SetSparkline(0, 0, new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 1, 1, 4), GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Line, new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting());
            GrapeCity.Xaml.SpreadSheet.Data.Sparkline sparkline2 = gcSpreadSheet1.Sheets[0].SetSparkline(1, 0, new GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 4), GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting());
            GrapeCity.Xaml.SpreadSheet.Data.SparklineGroup group = gcSpreadSheet1.Sheets[0].GroupSparkline(new GrapeCity.Xaml.SpreadSheet.Data.Sparkline[] { sparkline1, sparkline2 });
            //gcSpreadSheet1.Sheets[0].UngroupSparkline(group);

        For i As Integer = 0 To 1
            For j As Integer = 1 To 4
                Me.GcSpreadSheet1.Sheets(0).Cells(i, j).Value = i * 10 + j
            Next
        Next

Dim sparkline1 As GrapeCity.Xaml.SpreadSheet.Data.Sparkline = GcSpreadSheet1.Sheets(0).SetSparkline(0, 0, New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 1, 1, 4), GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Line, New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting())
Dim sparkline2 As GrapeCity.Xaml.SpreadSheet.Data.Sparkline = GcSpreadSheet1.Sheets(0).SetSparkline(1, 0, New GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 4), GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting())
Dim sparklinegroup As GrapeCity.Xaml.SpreadSheet.Data.SparklineGroup =GcSpreadSheet1.Sheets(0).GroupSparkline(New GrapeCity.Xaml.SpreadSheet.Data.Sparkline() {sparkline1, sparkline2})
'GcSpreadSheet1.Sheets(0).UngroupSparkline(SparklineGroup)

Target Platforms: Windows Server 2012, Windows RT

Reference

Worksheet Class
Worksheet Members