Random r = new Random();
int i, j;
for (i = 1; i <= 50; i++)
{
for (j = 1; j <= 3; j++)
{
fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString());
}
}
FarPoint.Win.Spread.Model.BaseSheetDataModel bsm;
bsm = (FarPoint.Win.Spread.Model.BaseSheetDataModel)fpSpread1.ActiveSheet.Models.Data;
MessageBox.Show(bsm.NextNonEmptyRow(1).ToString());
Dim r As New Random
Dim i, j As Integer
For i = 1 To 50
For j = 1 To 3
fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString())
Next j
Next i
Dim bsm As FarPoint.Win.Spread.Model.BaseSheetDataModel
bsm = fpSpread1.ActiveSheet.Models.Data
MessageBox.Show(bsm.NextNonEmptyRow(1).ToString())