MESCIUS SPREAD for Windows Forms 15.0J
GetNonEmptyNotesRowCount メソッド
使用例 

ノートを含む行の数を取得します。
構文
'宣言
 
Public Overridable Function GetNonEmptyNotesRowCount() As Integer
public virtual int GetNonEmptyNotesRowCount()

戻り値の型

セル ノートを含む行の数を表す Integer
使用例
次のサンプルコードは、メモを持つ列と行の数を返します。
fpSpread1.ActiveSheet.ColumnCount = 5;
fpSpread1.ActiveSheet.RowCount = 5;
fpSpread1.ActiveSheet.Cells[0, 0, 4, 4].Text = "This is a note test!";
fpSpread1.ActiveSheet.SetNote(0, 0, "I am a note!");
fpSpread1.ActiveSheet.SetNote(1, 1, "I am a note!");
fpSpread1.ActiveSheet.SetNote(2, 2, "I am a note!");
fpSpread1.ActiveSheet.SetNote(3, 3, "I am a note!");
fpSpread1.ActiveSheet.ShowNotes(true);

int r, c;
FarPoint.Win.Spread.Model.DefaultSheetDataModel dm;
dm = fpSpread1.ActiveSheet.Models.Data;
c = dm.GetNonEmptyNotesColumnCount;
r = dm.GetNonEmptyNotesRowCount;
MessageBox.Show(c.ToString() + " - " + r.ToString())
FpSpread1.ActiveSheet.ColumnCount = 5
FpSpread1.ActiveSheet.RowCount = 5
FpSpread1.ActiveSheet.Cells(0, 0, 4, 4).Text = "This is a note test!"
FpSpread1.ActiveSheet.SetNote(0, 0, "I am a note!")
FpSpread1.ActiveSheet.SetNote(1, 1, "I am a note!")
FpSpread1.ActiveSheet.SetNote(2, 2, "I am a note!")
FpSpread1.ActiveSheet.SetNote(3, 3, "I am a note!")
FpSpread1.ActiveSheet.ShowNotes(True)

Dim r, c As Integer
Dim dm As FarPoint.Win.Spread.Model.DefaultSheetDataModel
dm = FpSpread1.ActiveSheet.Models.Data
c = dm.GetNonEmptyNotesColumnCount
r = dm.GetNonEmptyNotesRowCount
MessageBox.Show(c.ToString() & " - " & r.ToString())
参照

DefaultSheetDataModel クラス
DefaultSheetDataModel メンバ

 

 


© MESCIUS inc. All rights reserved.