ExtendToLastItemWithData Field

Extends the selection to include the last item with data. This field is read-only.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared ReadOnly ExtendToLastItemWithData As Object

'Usage
 
Dim value As Object
 
value = SpreadActions.ExtendToLastItemWithData

public static readonly object ExtendToLastItemWithData

Example

This example sets up a map that uses the X key to extend the selection to the last item with data.

FarPoint.Win.Spread.InputMap im;
im = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.X, Keys.None), FarPoint.Win.Spread.SpreadActions.ExtendToLastItemWithData);

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.X, Keys.None), FarPoint.Win.Spread.SpreadActions.ExtendToLastItemWithData)

Remarks

This action extends the selection to the bottom and rightmost item that contains data in a multiple-item selection 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.

Reference

SpreadActions Class
SpreadActions Members