ScrollToLastCellWithData Field

Scrolls to display the last cell with data.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared ReadOnly ScrollToLastCellWithData As Object

'Usage
 
Dim value As Object
 
value = SpreadActions.ScrollToLastCellWithData

public static readonly object ScrollToLastCellWithData

Example

This example sets up a map that uses the S key to scroll to the last cell 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.ScrollToLastCellWithData);

Visual Basic

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.ScrollToLastCellWithData)

Remarks

This action scrolls the display to the top and leftmost cell 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.

Requirements

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

Reference

SpreadActions Class
SpreadActions Members