Spread for ASP.NET 11 Product Documentation
SwitchRowColumn Method (ExcelSparklineGroup)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ExcelSparklineGroup Class : SwitchRowColumn Method
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 creates sparklines.
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 10;
for (int i = 0; i < 3; i++)
for (int j = 0; j < 3; j++)
fpSpread1.Sheets[0].Cells[i, j].Value = j;

FarPoint.Web.Spread.Chart.SheetCellRange scr = new FarPoint.Web.Spread.Chart.SheetCellRange(fpSpread1.Sheets[0], 0, 0, 3, 3);
FarPoint.Web.Spread.Model.CellRange cr = new FarPoint.Web.Spread.Model.CellRange(3, 0, 1, 3);
fpSpread1.Sheets[0].AddSquareSparkline(scr, cr, FarPoint.Web.Spread.SparklineType.Column, new FarPoint.Web.Spread.ExcelSparklineSetting(), false);

FarPoint.Web.Spread.ExcelSparklineGroup esg = (FarPoint.Web.Spread.ExcelSparklineGroup)fpSpread1.Sheets[0].SparklineContainer[0];
listBox1.Items.Add(esg.IsSwitchable());
esg.SwitchRowColumn();
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
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.Web.Spread.Chart.SheetCellRange(FpSpread1.Sheets(0), 0, 0, 3, 3)
Dim cr As New FarPoint.Web.Spread.Model.CellRange(3, 0, 1, 3)
FpSpread1.Sheets(0).AddSquareSparkline(scr, cr, FarPoint.Web.Spread.SparklineType.Column, New FarPoint.Web.Spread.ExcelSparklineSetting(), False)

Dim esg As FarPoint.Web.Spread.ExcelSparklineGroup = DirectCast(FpSpread1.Sheets(0).SparklineContainer(0), FarPoint.Web.Spread.ExcelSparklineGroup)
ListBox1.Items.Add(esg.IsSwitchable())
esg.SwitchRowColumn()
See Also

Reference

ExcelSparklineGroup Class
ExcelSparklineGroup Members