OperationMode.SingleSelect on LeaveCell event

Posted by: ikrush on 8 September 2017, 1:33 pm EST

  • Posted 8 September 2017, 1:33 pm EST

    Hi!

    I have a problem when I put the OperationMode property of the spread as OperationMode.SingleSelect.
    On LeaveCell event of the Spread  when I use the keyboard cursors for navigation the value of the e.NewRow property always is -1
    Could you fix this for the next revision?

  • Replied 8 September 2017, 1:33 pm EST

    I am not seeing this behavior using 4.0.2005.  Make sure you have the latest maintenance release for the version you have.
  • Replied 8 September 2017, 1:33 pm EST

    Spread has always worked that way since it's inception using SingleSelect mode and the arrow keys.  Attempting to change it now in all likelihood would break other code.
  • Replied 8 September 2017, 1:33 pm EST

    Are you sure? I have been using Spread 6 for years and it hasn't this problem. Sincerely, I have bougth 9 licenses of Spread.NET v4 recently and I'm having lots of problems to implement it. When I search for any error on the forum I don't find a solution I find a trick to evade the problem and the code of my aplications grow more and more without control.
  • Replied 8 September 2017, 1:33 pm EST

    I'm using the latest version. If you use the keyboard arrows for navigation between rows the value of e.NewRow on LeaveCell event always is -1 but with the mouse it works.

  • Replied 8 September 2017, 1:33 pm EST

    With SingleSelect mode and using the arrow keys you would also need to use the SelectionChanged event when using the arrow keys.
  • Replied 8 September 2017, 1:33 pm EST

    That could be a temporary solution but in my opinion this annoying behaviour is a "bug". Sorry but I can't waste my time handling SelectionChanged event for all of my +1000 spreads in order to "fix" it. It's a nosense to program two different events for the same action. Could you fix it for the next revision?
  • Replied 8 September 2017, 1:33 pm EST

    I was referring to the .Net version of spread.  If you do a search on SingleSelect and LeaveCell you will find other posts regarding this issue.
  • Replied 8 September 2017, 1:33 pm EST

    Hello,


    In the Spread.NET productm, the LeaveCell event use to not fire at all when using the arrow keys to move the active row selected. This was reported as bug #21887 and fixed December last year. However the fix hardcoded -1 for the newRow and newColumn parameters. I have reported a new bug (#23269) for the development team to fix this for the next maintenance release.

  • Replied 8 September 2017, 1:33 pm EST

    Thank you very much!
Need extra support?

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

Learn More

Forum Channels