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

    Son,

    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