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

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ExcelSparklineGroup Class
ExcelSparklineGroup Members