MESCIUS SPREAD for Windows Forms 17.0J
UnGroupSparkline(CellRange) メソッド

セル範囲。
グループされたスパークラインのグループを解除します。
構文
'Declaration
 
Public Overloads Sub UnGroupSparkline( _
   ByVal cellRange As CellRange _
) 
public void UnGroupSparkline( 
   CellRange cellRange
)

パラメータ

cellRange
セル範囲。
次のサンプルコードは、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(new FarPoint.Win.Spread.Model.CellRange(1, 5, 3, 1));
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(new FarPoint.Win.Spread.Model.CellRange(1, 5, 3, 1))
参照

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

 

 


© MESCIUS inc. All rights reserved.