Description: Working in a calc document. Auto recalc stops working. v6.1 dev and v5.4.3.2 Steps to Reproduce: 1. work on spreadsheet 2. change field contents 3. recalc stops working Actual Results: see rows 143-156 around col x Expected Results: to count correctly Reproducible: Always User Profile Reset: No Additional Info: have included before and after docs. User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
Created attachment 138546 [details] File where reclac no longer works
Created attachment 138547 [details] file before recalc stopped working
Created attachment 138607 [details] formula Hi, see W145 - W149 : in the formula is "=" twice.
(In reply to raal from comment #3) > Created attachment 138607 [details] > formula > > Hi, > see W145 - W149 : in the formula is "=" twice. Elmar: what do you think?
Interesting. I wonder how that happened. Thank you. Did not see that. == should produce an error - i did not find in the docum any reference to what such a When I tried to remove the double == it kept on putting it back. So I deleted the contents of cells and copied the columns to a new workbook The the problem was solved. Row 144 then gave me error 522, which I cleared by setting Iterations on. However, I do not understand why that should be, since the simple addition in row 144 should not have a problem if the formulas in rows 145-149 produce results (and they are the ones that involve ranges) Actually, if I think about that. It does make sense - you cannot resolve row 144 until rows 145-149 have been calculated. However, why does row 143 not give the same error? Also: the calculation still doe not happen - for example if I add a "C" in row 137, it is increment row 146 by 1. It does not. But in version5.4 it does. If I then save the v5.4 file and open it in v6.1dev, it seems to work fine - maybe the DEV file was corrupted at some point? I then created an empty workbook in v6.1dev and copied the columns from the working sheet to the new workbook. Seems to work. So will try it out again over the next few days.
(In reply to Elmar from comment #5) > So will try it out again over the next few days. Are you happy to close this?
(In reply to Buovjaga from comment #6) > (In reply to Elmar from comment #5) > > So will try it out again over the next few days. > > Are you happy to close this? Yes, I do not have the problem anymore