SwitchRowColumn Method (ExcelSparklineGroup)

Visual Basic
C#

'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

This example uses the SwitchRowColumn method.

C#

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();

Visual Basic

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()

Reference

ExcelSparklineGroup Class
ExcelSparklineGroup Members