https://bugs.documentfoundation.org/show_bug.cgi?id=145248
--- Comment #5 from Colin <[email protected]> --- Further insight. I have been experimenting with the "scope" of the error as I had noticed that attempting to edit or replace a portion of the formula which may be embedded in perhaps the second or third level of parenthesis often resulted in the error condition. I now believe that the anomaly is connected with the validity of the underlying formula. That is to say If I attempt to correct a formula that contains a syntax error and results in an error message then the editing appears to proceed without the anomaly - it allows me to correct the invalid entry without hindrance. However, if I endeavour to edit a correctly formulated statement with a valid result then the anomaly occurs and it will destroy the syntax and render the formula invalid - even as insignificant as changing the target reference or the operator for a SUBTOTAL()function. -- You are receiving this mail because: You are the assignee for the bug.
