Spread Windows Forms 11.0 Product Documentation
ResetColumnIndices Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > ScrollingContentInfo Class : ResetColumnIndices Method
Resets the ColumnIndices property to its default value.
Syntax
'Declaration
 
Public Sub ResetColumnIndices() 
'Usage
 
Dim instance As ScrollingContentInfo
 
instance.ResetColumnIndices()
public void ResetColumnIndices()
Example
Uncomment the ResetColumnIndices method to reset the vertical data in the scrolling tip.
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()
See Also

Reference

ScrollingContentInfo Class
ScrollingContentInfo Members