Created attachment 117058 [details] Change A1 to see the bug When changing a cell (eg A1 in the attached spreadsheet), I get numerous Err:522 cells, not always, but usually. Setting on them and pressing [F9] does not remove them, but [CNTL][SHIFT][F9] removes all. This happens only after I installed 4.4.4.3 yesterday. The spreadsheets involved were affected by bug 89957.
Created attachment 117066 [details] Screenshot after change A1 Hi @David, I can't reproduce with: Win7x64Ultimate Version: 4.4.4.3 Build ID: 2c39ebcf046445232b798108aa8a7e7 Attached screenshot after change A1.
Thanks for attempting to reproduce this. Renaming my user profile solves the problem. I'm now trying to find out what in my user profile is causing the error.
The registrymodifications.xcu file causes the problem. I have kept it and can post it here if it is of interest.
I have found several times that the issues are only with that file. Please attach here, of course after deleting any personal information like user data. Added @Joel as CC, because recently he was looking for that corrupted user profiles. Please could change the status from FIXED to WORKSFORME, in reality nothing was fixed.
Created attachment 117073 [details] Corrupt user profile
This error has started to appear again. It disappeared for a few days when I made myself a new user profile.
This bug has got more and more frequent. For some time [CNTL][SHIFT][F9] got rid of the Err: 522 cells. Then it moved the Err: 522 to a different set of cells. Now nothing will remove the Err: 522 cells. Renaming the user profile has no effect. I have attached the spreadsheet.
Created attachment 117305 [details] Spreadsheet exhibiting bug
Sorry @David, I think there is a circular reference: wds.CA (corrected_clue) wds.BU wds.G wds.B $w.$A$1:AB1 corrected_clue What can help to find this issues is: Menu/Tools/Detective/Trace error If you need to use in that way then activate the option: Menu/Tools/LibreOffice calc/calculate - Iterative reference It can limits how many times to do recursive calculations.
Many thanks. You are right. The offending code has been unchanged for months. I don't understand why: at first there were no Err:522 errors then, [CNTL][SHIFT][F9] removed them then, renaming the user profile removed them then, [CNTL][SHIFT][F9] moved the errors elsewhere then, now, it is impossible to remove them.
"Hard recalc" [Shif+Ctrl+F9] forces the whole recalculitation while "Autorecalculate" or [F9] recalculate a cell when there are changes in their precedents. And also there are several fixed bugs with issues in situations where Autocalculate didn't work properly. Maybe it can explain why now circular error is always showed and not before. I think for now we can't consider this as a bug, please if you are not agree, reopen it.
Thanks for your help. I agree that it should not be a bug. I am still getting occasional cells with Err: 522 (in a different part of the the spreadsheet). I have reduced the number of iterations to 3 in Menu/Tools/LibreOffice calc/calculate - Iterative reference When I set on the cell in error and do Menu/Tools/Detective/Trace error, as you suggest, the error disappears and the expected value appears in the cell and I get no error trace. Am I doing something wrong?
It's really difficult to know what happens in a so complex file, test if change the value minimum change for iterative references option. I have done several calculations with [F9] and with [Ctrl+Shift+F9] (hard recalc), and I can't see circular errors. (minimum change 0.001), maybe some other global option produces the error.
The content of attachment 117073 [details] has been deleted