PowerTools SPREAD for Windows Forms 10.0J
UnGroupSparkline(Int32,Int32) メソッド


行。
列。
スパークラインはカレントセルと同じグループにある場合、特定位置でそのグループを解除します。
構文
'Declaration
 
Public Overloads Sub UnGroupSparkline( _
   ByVal row As Integer, _
   ByVal column As Integer _
) 
'使用法
 
Dim instance As Cell
Dim row As Integer
Dim column As Integer
 
instance.UnGroupSparkline(row, column)
public void UnGroupSparkline( 
   int row,
   int column
)

パラメータ

row
行。
column
列。
次のサンプルコードは、UnGroupSparkline メソッドを使用します。
fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5");
fpSpread1.Sheets[0].SetClip(1, 0, 1, 5, "5\t4\t3\t2\t1");
fpSpread1.Sheets[0].SetClip(2, 0, 1, 5, "1\t2\t3\t2\t1");
FarPoint.Win.Spread.ExcelSparkline es = new FarPoint.Win.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets[0], new FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 5));
FarPoint.Win.Spread.ExcelSparklineGroup esg = new FarPoint.Win.Spread.ExcelSparklineGroup(new FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column);
esg.Add(es);

FarPoint.Win.Spread.ExcelSparkline es1 = new FarPoint.Win.Spread.ExcelSparkline(1, 5, fpSpread1.Sheets[0], new FarPoint.Win.Spread.Model.CellRange(1, 0, 1, 5));
FarPoint.Win.Spread.ExcelSparkline es2 = new FarPoint.Win.Spread.ExcelSparkline(2, 5, fpSpread1.Sheets[0], new FarPoint.Win.Spread.Model.CellRange(2, 0, 1, 5));
FarPoint.Win.Spread.ExcelSparklineGroup esg1 = new FarPoint.Win.Spread.ExcelSparklineGroup(new FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Line);
esg1.Add(es1);
esg1.Add(es2);
fpSpread1.Sheets[0].SparklineContainer.Add(esg);
fpSpread1.Sheets[0].SparklineContainer.Add(esg1);
fpSpread1.Sheets[0].Cells[0, 5].UnGroupSparkline(1, 5);
fpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" & vbTab & "2" & vbTab & "3" & vbTab & "4" & vbTab & "5")
fpSpread1.Sheets(0).SetClip(1, 0, 1, 5, "5" & vbTab & "4" & vbTab & "3" & vbTab & "2" & vbTab & "1")
fpSpread1.Sheets(0).SetClip(2, 0, 1, 5, "1" & vbTab & "2" & vbTab & "3" & vbTab & "2" & vbTab & "1")
Dim es As New FarPoint.Win.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets(0), New FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 5))
Dim esg As New FarPoint.Win.Spread.ExcelSparklineGroup(New FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column)
esg.Add(es)

Dim es1 As New FarPoint.Win.Spread.ExcelSparkline(1, 5, fpSpread1.Sheets(0), New FarPoint.Win.Spread.Model.CellRange(1, 0, 1, 5))
Dim es2 As New FarPoint.Win.Spread.ExcelSparkline(2, 5, fpSpread1.Sheets(0), New FarPoint.Win.Spread.Model.CellRange(2, 0, 1, 5))
Dim esg1 As New FarPoint.Win.Spread.ExcelSparklineGroup(New FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Line)
esg1.Add(es1)
esg1.Add(es2)
fpSpread1.Sheets(0).SparklineContainer.Add(esg)
fpSpread1.Sheets(0).SparklineContainer.Add(esg1)
fpSpread1.Sheets(0).Cells(0, 5).UnGroupSparkline(1, 5)
参照

Cell クラス
Cell メンバ
オーバーロード一覧

 

 


© 2004-2017, GrapeCity inc. All rights reserved.