Posted 4 October 2022, 1:33 pm EST
On my application, i has 2 cell (A1, A2) are locked. So, when user operate:
- Select A1 and Ctrl + C => select A2 and Ctrl + V.
- Hover bottom right corner of A1 => fill handle to A2.
InvalidOperation is fired. In this case, i’m using alert/modal to show message. Beside of that, i want to prevent user operate any action such as arrow key. So, i’m using:
This code is working well for case “Fill handle”. But in case “Copy/Paste”, after close alert/modal, although SpreadJS is lost focus, user can still using arrow key on SpreadJS.
Please check my sample source code and give me solution. SpreadJS_FocusFalse.zip