when spread is Edit Mode, Direction Key can't Move...

Posted by: son-fp on 8 September 2017, 2:17 pm EST

  • Posted 8 September 2017, 2:17 pm EST

    [version window form 4.0] 

    Format -> Spread -> Setting 

    Cells Always in Edit Mode          check

    Editing Replaces Existing Text   check


    I Make Edit Mode..

    Up,Dwon Key[KeyBoard] is Move...

    But Left, Right Key is not move....


  • Replied 8 September 2017, 2:17 pm EST


    Using the AcceptArrowKeys with the None option will give you the desired behavior of moving to next cells on pressing the left/right arrow key when in Edit mode. The below snippet can be used:


           Dim ct As New FarPoint.Win.Spread.CellType.GeneralCellType
            ct.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.None
            FpSpread1.Sheets(0).DefaultStyle.CellType = ct


    And for the detailed explanation of this behavior, please refer to this earlier discussed thread.

  • Replied 8 September 2017, 2:17 pm EST

    Thanks your favor...SureshD

    It well done....

Need extra support?

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

Learn More

Forum Channels