Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadSurfaceChart Class / SwitchRowColumn Method
Example


In This Topic
    SwitchRowColumn Method (SpreadSurfaceChart)
    In This Topic
    Switches the row and column of the chart.
    Syntax
    'Declaration
     
    Public Function SwitchRowColumn() As Boolean
    'Usage
     
    Dim instance As SpreadSurfaceChart
    Dim value As Boolean
     
    value = instance.SwitchRowColumn()
    public 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