Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ExcelSparklineGroup Class / SwitchRowColumn Method
Example


In This Topic
    SwitchRowColumn Method (ExcelSparklineGroup)
    In This Topic
    Switches sparkline rows or columns.
    Syntax
    'Declaration
     
    Public Function SwitchRowColumn() As Boolean
    'Usage
     
    Dim instance As ExcelSparklineGroup
    Dim value As Boolean
     
    value = instance.SwitchRowColumn()
    public bool SwitchRowColumn()

    Return Value

    True if switch action is finished; otherwise, false
    Example
    This example uses the SwitchRowColumn method.
    for (int i = 0; i < 3; i++)
    for (int j = 0; j < 3; j++)
    fpSpread1.Sheets[0].Cells[i, j].Value = j;
    
    FarPoint.Win.Spread.Chart.SheetCellRange scr = new FarPoint.Win.Spread.Chart.SheetCellRange(fpSpread1.Sheets[0], 0, 0, 3, 3);
    FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(3, 0, 1, 3);
    fpSpread1.Sheets[0].AddSquareSparkline(scr, cr, FarPoint.Win.Spread.SparklineType.Column, new FarPoint.Win.Spread.ExcelSparklineSetting(), false);
    
    FarPoint.Win.Spread.ExcelSparklineGroup esg = (FarPoint.Win.Spread.ExcelSparklineGroup)fpSpread1.Sheets[0].SparklineContainer[0];
    listBox1.Items.Add(esg.IsSwitchable());
    esg.SwitchRowColumn();
    For i As Integer = 0 To 2
        For j As Integer = 0 To 2
         FpSpread1.Sheets(0).Cells(i, j).Value = j
        Next
    Next
    
    Dim scr As New FarPoint.Win.Spread.Chart.SheetCellRange(FpSpread1.Sheets(0), 0, 0, 3, 3)
    Dim cr As New FarPoint.Win.Spread.Model.CellRange(3, 0, 1, 3)
    FpSpread1.Sheets(0).AddSquareSparkline(scr, cr, FarPoint.Win.Spread.SparklineType.Column, New FarPoint.Win.Spread.ExcelSparklineSetting(), False)
    
    Dim esg As FarPoint.Win.Spread.ExcelSparklineGroup = DirectCast(FpSpread1.Sheets(0).SparklineContainer(0), FarPoint.Win.Spread.ExcelSparklineGroup)
    ListBox1.Items.Add(esg.IsSwitchable())
    esg.SwitchRowColumn()
    See Also