Spread WPF Documentation
SwitchRowColumn Method (SpreadChart)
Example 


Switches the row and column of the chart.
Syntax
'Declaration
 
Public Function SwitchRowColumn() As System.Boolean
'Usage
 
Dim instance As SpreadChart
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[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 }, { 7 }, { 8 }, { 9 }, { 10 } });
GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 300, 300);
GcSpreadSheet1.ActiveSheet.Charts.Add(chart);
if (chart.CanSwitchRowColumn)
 chart.SwitchRowColumn();
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}})
Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 300, 300)
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
If (chart.CanSwitchRowColumn) Then
chart.SwitchRowColumn()
End If
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

SpreadChart Class
SpreadChart Members

 

 


Copyright © GrapeCity, inc. All rights reserved.