Spread Windows Forms 11.0 Product Documentation
ScrollToLastRowWithData Field
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadActions Class : ScrollToLastRowWithData Field
Scrolls to display the last row with data.
Syntax
'Declaration
 
Public Shared ReadOnly ScrollToLastRowWithData As Object
'Usage
 
Dim value As Object
 
value = SpreadActions.ScrollToLastRowWithData
public static readonly object ScrollToLastRowWithData
Example
This example sets up a map that uses the S key to scroll to the last row in this sheet containing data.
FarPoint.Win.Spread.InputMap im;
im = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.S, Keys.None), FarPoint.Win.Spread.SpreadActions.ScrollToLastRowWithData);
Dim im As FarPoint.Win.Spread.InputMap
im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused)
im.Put(New FarPoint.Win.Spread.Keystroke(Keys.S, Keys.None), FarPoint.Win.Spread.SpreadActions.ScrollToLastRowWithData)
Remarks

This action scrolls the display to the bottom row that contains data in the sheet.

You can use this action along with a custom key combination by defining your own input or action map. For more information about maps, see Managing Keyboard Interactions.

See Also

Reference

SpreadActions Class
SpreadActions Members