Spread Windows Forms 7.0 Product Documentation
Customizing the Position in the Display
Support Options
Spread Windows Forms 7.0 Product Documentation > Developer's Guide > Customizing Sheet Interaction > Customizing Interaction with a Sheet > Customizing the Position in the Display

Glossary Item Box

You can customize the position of the spreadsheet in the display by choosing a row, column, or cell, and moving it to a particular position in the displayed portion of the spreadsheet in the Spread component.

Use the ShowRow, ShowColumn, ShowCell, or ShowActiveCell methods in the FpSpread class, and the HorizontalPosition and VerticalPosition enumerations. These methods scroll the display until the specified item is displayed in the specified location.

Using Code

This example uses ShowActiveCell method.

Example

C# Copy Code
fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Top, FarPoint.Win.Spread.HorizontalPosition.Center);
VB Copy Code
FpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Top, FarPoint.Win.Spread.HorizontalPosition.Center)
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.