ResetColumnIndices Method | Spread Windows Forms 13.0 Product Documentation

ResetColumnIndices Method

In This Topic

Resets the ColumnIndices property to its default value.

Syntax

Visual Basic
C#

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

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

Reference

ScrollingContentInfo Class
ScrollingContentInfo Members

Product Support Forum | Print this page