Spread WPF Documentation
UngroupSparkline Method
Example 


The group.
Ungroups the sparklines in the group.
Syntax
'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.
Example
This example uses the UngroupSparkline method.
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;
     }
  }

Sparkline sparkline1= gcSpreadSheet1.Sheets[0].SetSparkline(0, 0, new CellRange(0, 1, 1, 4), DataOrientation.Horizontal, SparklineType.Line, new SparklineSetting());
Sparkline sparkline2 = gcSpreadSheet1.Sheets[0].SetSparkline(1, 0, new CellRange(1, 0, 1, 4), DataOrientation.Horizontal, SparklineType.Column, new SparklineSetting());
SparklineGroup group= gcSpreadSheet1.Sheets[0].GroupSparkline(new 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 Sparkline = GcSpreadSheet1.Sheets(0).SetSparkline(0, 0, New CellRange(0, 1, 1, 4), DataOrientation.Horizontal, SparklineType.Line, New SparklineSetting())
Dim sparkline2 As Sparkline = GcSpreadSheet1.Sheets(0).SetSparkline(1, 0, New CellRange(1, 0, 1, 4), DataOrientation.Horizontal, SparklineType.Column, New SparklineSetting())
Dim sparklinegroup As SparklineGroup =GcSpreadSheet1.Sheets(0).GroupSparkline(New Sparkline() {sparkline1, sparkline2})
'GcSpreadSheet1.Sheets(0).UngroupSparkline(SparklineGroup)
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.