MESCIUS SPREAD for Windows Forms 17.0J
SwitchRowColumn メソッド (ExcelSparklineGroup)

スパークライン行または列を入れ替えます。
構文
'Declaration
 
Public Function SwitchRowColumn() As Boolean
public bool SwitchRowColumn()

戻り値の型

入れ替え動作が完了した場合は True、それ以外の場合は False。
次のサンプルコードは、SwitchRowColumnメソッドを使用します。
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()
参照

ExcelSparklineGroup クラス
ExcelSparklineGroup メンバ

 

 


© MESCIUS inc. All rights reserved.