FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread.Model 名前空間 > DefaultSheetDataModel クラス : NextNonEmptyRowFormula メソッド |
'使用法 Dim instance As DefaultSheetDataModel Dim row As Integer Dim value As Integer value = instance.NextNonEmptyRowFormula(row)
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8); fpSpread1.ActiveSheet.Models.Data = dataModel; fpSpread1.Sheets[0].Cells[1, 1].Value = 1; fpSpread1.Sheets[0].Rows[3].Formula = "B2+1"; listBox1.Items.Add(dataModel.NextNonEmptyRowFormula(-1).ToString());
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8) FpSpread1.ActiveSheet.Models.Data = dataModel fpSpread1.Sheets(0).Cells(1, 1).Value = 1 fpSpread1.Sheets(0).Rows(3).Formula = "B2+1" listBox1.Items.Add(dataModel.NextNonEmptyRowFormula(-1).ToString())