ResetColumnIndices Method

Visual Basic
C#

'Declaration
 
Public Sub ResetColumnIndices()

'Usage
 
Dim instance As ScrollingContentInfo
 
instance.ResetColumnIndices()

public void ResetColumnIndices()

Uncomment the ResetColumnIndices method to reset the vertical data in the scrolling tip.

C#

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();

Visual Basic

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()

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ScrollingContentInfo Class
ScrollingContentInfo Members