Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadSurfaceChart Class / CanSwitchRowColumn Property
Example


In This Topic
    CanSwitchRowColumn Property (SpreadSurfaceChart)
    In This Topic
    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 Boolean
    'Usage
     
    Dim instance As SpreadSurfaceChart
    Dim value As Boolean
     
    value = instance.CanSwitchRowColumn
    public 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