Navigating in a spread

Posted by: nils on 8 September 2017, 1:02 pm EST

  • Posted 8 September 2017, 1:02 pm EST

    Hi!


    My problem is:


    When editing a spread and the active cell is the last column, then I want to move to next row and the first column and make that cell active. I'm using this code to make it possible to use Enter-key when navigating:


    inputmap1 = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused)


    inputmap1.Put(New FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None),  FarPoint.Win.Spread.SpreadActions.MoveToNextColumn).


    In short, when I'm in the last column and use Enter-key nothing happens.


    Regards


    Nils

  • Replied 8 September 2017, 1:02 pm EST

    Nils -

    Change your SpreadAction to MoveToNextColumnWrap.
  • Replied 8 September 2017, 1:02 pm EST

    Thanks!


    It work's well!


    Regards


    Nils

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels