Posted 25 October 2017, 4:22 am EST
If a wrong value (e.g. a wrong formula) is entered into a cell and Delete button is pressed over it, the whole spreadsheet gets stuck rendering the sheet unusable. If we refresh the webpage however, the sheet becomes active again, but the cell which contains that wrong value/formula, retains the value and the value cannot be changed. On pressing delete button keeping that cell on focus makes the sheet stuck again. Steps to regenerate the scenario are as under:
Step 1: Type any numeric value in a cell.
Step 2: In another cell type equals sign (=) and give reference to the first cell in which you typed some value, put a percent sign (%) after cell reference and press Enter key.
Step 3: Edit the second cell (in which you gave reference of the first cell), put
a dollar sign ($) before the percent mark and hit Enter key. Notice, you won’t be able to change the cell value now.
Step 4. Now move to the second cell again and press Delete key. Whole sheet will get jammed as a result. Some other cases result in the same behavior.
Note: This happens in GrapeCity online demo as well. Link as under:
https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/quickstart/
I am attaching a video link also, which captures the above problem, for your reference.
Video Link:
https://drive.google.com/file/d/0B_MwmqKzjj_Yb0hWTWFUVi1FbWs/view?usp=sharing
Regards
