Switch sparkline rows or columns.
Syntax
Visual Basic (Declaration) | |
---|
Public Function SwitchRowColumn() As Boolean |
C# | |
---|
public bool SwitchRowColumn() |
Return Value
True if Switch action is finished; otherwise False
Example
This example creates sparklines.
C# | Copy Code |
---|
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(); |
Visual Basic | Copy Code |
---|
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() |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also