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:

    <FONT size=2>

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

    </FONT><FONT size=2>

    inputmap1.Put(</FONT><FONT color=#0000ff size=2>New</FONT><FONT size=2> FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None),  FarPoint.Win.Spread.SpreadActions.MoveToNextColumn).</FONT>


    <FONT size=2>In short, when I'm in the last column and use Enter-key nothing happens.</FONT>


    <FONT size=2>Regards</FONT>


    <FONT size=2>Nils

    </FONT>
  • 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