Spread WPF Documentation
SwitchRowColumn Method (SpreadSurfaceChart)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > SpreadSurfaceChart Class : SwitchRowColumn Method
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
See Also

Reference

SpreadSurfaceChart Class
SpreadSurfaceChart Members