int i;
for (i=0; i < 20; i++)
{
fpSpread1.ActiveSheet.Cells[i, 0].Text = i + "test";
fpSpread1.ActiveSheet.Cells[i, 2].Text = i + "text";
}
fpSpread1.ScrollTipPolicy = FarPoint.Win.Spread.ScrollTipPolicy.Both;
FarPoint.Win.Spread.ScrollingContentInfo scrollingContentInfo = new FarPoint.Win.Spread.ScrollingContentInfo();
scrollingContentInfo.ColumnIndices = "0,2";
scrollingContentInfo.MaxHeight = 100;
scrollingContentInfo.RowNumberPolicy = FarPoint.Win.Spread.ScrollingContentRowNumberPolicy.Last;
fpSpread1.Sheets[0].ScrollingContentInfo = scrollingContentInfo;
//scrollingContentInfo.Reset();
//scrollingContentInfo.ResetColumnIndices();
Dim i As Integer
For i = 0 To 20
FpSpread1.ActiveSheet.Cells(i, 0).Text = i & "test"
FpSpread1.ActiveSheet.Cells(i, 2).Text = i & "text"
Next
FpSpread1.ScrollTipPolicy = FarPoint.Win.Spread.ScrollTipPolicy.Both
Dim scrollingContentInfo As New FarPoint.Win.Spread.ScrollingContentInfo()
scrollingContentInfo.ColumnIndices = "0,2"
scrollingContentInfo.MaxHeight = 100
scrollingContentInfo.RowNumberPolicy = FarPoint.Win.Spread.ScrollingContentRowNumberPolicy.Last
FpSpread1.Sheets(0).ScrollingContentInfo = scrollingContentInfo
'scrollingContentInfo.Reset()
'scrollingContentInfo.ResetColumnIndices()