Spread Windows Forms 8.0 Product Documentation
SwitchRowColumn Method (ExcelSparklineGroup)
Example 


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

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

See Also

Reference

ExcelSparklineGroup Class
ExcelSparklineGroup Members

 

 


Copyright © GrapeCity, inc. All rights reserved.