In Excel, in a protected sheet when you press the TAB key it moves to the next unlocked cell and pressing SHIFT-TAB takes you to the previous unlocked cell. Please can you add this behaviour and in addition also make it apply when pressing the ENTER and SHIFT-ENTER key
Add the capability to control cell navigation using the Enter key or Shift+Enter key combination in a protected worksheet
Answers approved by DevExpress Support
created 10 years ago
(modified 10 years ago)
We have implemented the functionality described in this ticket. It will be included in our next update(s).
Please check back and leave a comment to this response to let us know whether or not this solution addresses your concerns.
Additional information:
With VCL 14.2.3, we extended the TdxSpreadSheetOptionsBehavior class with the EnterKeyNavigation property, which allows you to choose how the Enter key or Shift+Enter key combination moves cell focus between cells within the current column in a protected worksheet:
- Default behavior when cell focus moves consequentially through both locked and unlocked cells (eknDefault);
- Cell focus moves consequentially through unlocked cells, skipping locked ones (eknSkipLockedCells).
Comments
(3)
SM
10 years ago
Thanks for doing this. Have you done anything regarding the behaviour of pressing Tab and Shift Tab which in Excel moves to the next unlocked cell in the current row, then moves to the next unlocked cell in the next/previous row, etc?
Hello Stephen,
We have fixed the erroneous navigation using the Tab, Enter, and Shift key combinations within cell selections reported in a separate ticket. We expect to have all the issues addressed in VCL 14.2.3.
Hello Stephen,
Thank you for your idea. We will consiger implementing it in future versions of our controls, but it can take us some time.
We greatly appreciate your understanding.
This is very important to us since the current spreadsheet control we use has this functionality so our users would expect it to behave like this when we release a build using your spreadsheet control so I was wondering if there are there any events or protected methods I could override that would allow me to do this myself?
Hello Stephen,
This functionality is not implemented yet. However, I believe that it will be realized in VCL 14.1.7 or VCL 14.2.2 (the next version after VCL 14.2 Beta).
Ok, thanks.
Can you confirm if this made it into the 14.2.2 release that has just been made?
Hello Stephen,
I am afraid that we have not implemented this functionality yet.
Ok, but please can you ensure that it doesn't get forgotten about since as I previously stated we do need this functionality sooner than later.
Stephen, our developers are working on this request. We will inform you as soon as we have any results.
Ok, thanks for the update.