Spread Silverlight Documentation
SwitchRowColumn Method (SpreadSurfaceChart)
Example 


Switches the row and column of the chart.
Syntax
'Declaration
 
Public Function SwitchRowColumn() As System.Boolean
'Usage
 
Dim instance As SpreadSurfaceChart
Dim value As System.Boolean
 
value = instance.SwitchRowColumn()
public System.bool SwitchRowColumn()

Return Value

If the switching process is successful, returns true; otherwise, returns false.
Example
This example uses the SwitchRowColumn method.
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 2 }, { 3 }, { 5 } });
GcSpreadSheet1.ActiveSheet.SetArray(0, 1, new object[,] { { 3 }, { 6 }, { 4 } });
GcSpreadSheet1.ActiveSheet.SetArray(0, 2, new object[,] { { 5 }, { 1 }, { 3 } });
GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart schart = new GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart("SChart", GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChartType.Surface, 0, 0, 300, 300);
schart.DataFormula = "Sheet1!$A$1:$C$3";
this.GcSpreadSheet1.ActiveSheet.SurfaceCharts.Add(schart);
if (schart.CanSwitchRowColumn)
schart.SwitchRowColumn();
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New object(,) { { 2 }, { 3 }, { 5 } })
GcSpreadSheet1.ActiveSheet.SetArray(0, 1, New object(,) { { 3 }, { 6 }, { 4 } })
GcSpreadSheet1.ActiveSheet.SetArray(0, 2, New object(,) { { 5 }, { 1 }, { 3 } })
Dim schart As New GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart("SChart", GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChartType.Surface, 0, 0, 300, 300)
schart.DataFormula = "Sheet1!$A$1:$C$3"
GcSpreadSheet1.ActiveSheet.SurfaceCharts.Add(schart)
If (schart.CanSwitchRowColumn) Then
schart.SwitchRowColumn()
End If
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

SpreadSurfaceChart Class
SpreadSurfaceChart Members

 

 


Copyright © GrapeCity, inc. All rights reserved.