Spread WPF Documentation
CanSwitchRowColumn Property (SpreadSurfaceChart)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > SpreadSurfaceChart Class : CanSwitchRowColumn Property
Gets a value that indicates whether the user can switch the rows and columns of the surface chart.
Syntax
'Declaration
 
Public ReadOnly Property CanSwitchRowColumn As System.Boolean
'Usage
 
Dim instance As SpreadSurfaceChart
Dim value As System.Boolean
 
value = instance.CanSwitchRowColumn
public System.bool CanSwitchRowColumn {get;}

Property Value

true if user can switch rows and columns of the surface chart; otherwise, false.
Remarks
This sets whether the user can switch the row and column on the surface chart.
Example
This example uses the CanSwitchRowColumn property.
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