PowerTools SPREAD for Windows Forms 8.0J
RowCount プロパティ (SheetSelectionModelEventArgs)


選択範囲に含まれる行の数を取得します。
構文
'Declaration
 
Public ReadOnly Property RowCount As Integer
'使用法
 
Dim instance As SheetSelectionModelEventArgs
Dim value As Integer
 
value = instance.RowCount
public int RowCount {get;}

プロパティ値

影響を受けた行の数を表す Integer
次のサンプルコードは、選択範囲内の行数を返します。
FarPoint.Win.Spread.Model.BaseSheetSelectionModel model;

model = (FarPoint.Win.Spread.Model.BaseSheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
model.AddSelection(0, 0, 2, 2);

model.Changed += new FarPoint.Win.Spread.Model.SheetSelectionModelEventHandler(model_SelectionModelChanged);
    
private void button1_Click(object sender, System.EventArgs e)
{
    model.AddSelection(4, 2, 2, 3);
}

private void model_SelectionModelChanged(object sender, FarPoint.Win.Spread.Model.SheetSelectionModelEventArgs e)
{
    textBox1.Text = e.RowCount.ToString();
}
Friend WithEvents model As FarPoint.Win.Spread.Model.BaseSheetSelectionModel

model = FpSpread1.ActiveSheet.Models.Selection
model.AddSelection(0, 0, 2, 2)

Dim h As FarPoint.Win.Spread.Model.SheetSelectionModelEventHandler = AddressOf model_SelectionModelChanged
AddHandler model.Changed, h

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    model.AddSelection(4, 2, 2, 3)
End Sub

Private Sub model_SelectionModelChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetSelectionModelEventArgs)
    TextBox1.Text = e.RowCount.ToString()
End Sub
参照

SheetSelectionModelEventArgs クラス
SheetSelectionModelEventArgs メンバ

 

 


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