Spread Silverlight 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, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.