(0)
- Use the in-place editor of the grid to type an erroneous formula (e.g. '=A')
- Navigate to another cell by click, arrow keys, or complete editing by ENTER key --> the incorrect formula is detected, the parser's error message is displayed, and navigation is reverted, the grid is in the erroneous cell in edit mode again.
- I got the same result here
(1)
- Use the in-place editor of the grid, type an erroneous formula
- Click into the TsCellEdit box. The error message appears, but the cell is erased - this is not good.
I got the same result here
Note that the cell is not erased but reverted to its original value. If the cell contains 123 before the errorneous formula is entered, it will revert to 123 after the error message appears. i.e. the user will be editing the cell containing 123 now. If the cell was empty, it would revert to empty cell (thus the formula appeared to be erased).
This above test result is consistent with the following cases:
(1a)
Goto cell A1, in tsEdit key in =aa then click into cell A1 in the grid. Click OK when error message appears. The cell will revert to the original value of A1.
(1b)
Goto cell A1, in tsEdit key in =aa then click into cell C1 in the grid. Click OK when error message appears. The cell will revert to the original value of C1.
I think the above behaviour is acceptable.
(2)
- Use the TsCellEdit box to type an erroneous formula
- When the error message comes up, press ENTER to close it (don't click "OK") -> the box comes up again and again (However, if you click OK with the mouse, the message box does not appear again.
I got the same result here
(3)
- Use the TsCellEdit box to type an erroneous formula
- After typiing don't press ENTER, but click into the cell. The formula is erased. The error message box comes up. Press ENTER or click OK to close the error message. A selection rectangle appears in the grid which follows the mouse. You must click anywhere to return to normal operation.
Same result but see my comment in (1) above
(4) Goto cell A1, do steps in (0) above. When the erroneous cell is back to edit mode, change the formula to =B1
Now we can see the formula B1 in tsEdit whenever we are in cell A1, however cell A1 would not show any value even if B1 contains a valid number.
Same thing would happen if you key in erroneous formula in TsCellEdit then changed it to a valid formula.
(5) At times, heaptrc shows there is unfreed memory block, but I am yet to find the way to reproduce this.