I had to turn off auto calculate in a l cal file I have been using for several years as the totals column kept being put into cell protection mode causing the column to show ERR. I tired resting the column to edit, saving the file as a new file, copying the file to another file & redoing the calculation field, nothing worked. This started happening right after updating to this version. The only way I could fix this was to turn off the autocalc on that column & force a recalculate hard to update the column each time.
Which error number is shown?
The file have private data? Can you share it, or a reduced sample file that show the problem?
1 Like
No error code just the letters ERR in the column. This has sensitive data so I will not share the file. If I turn off automatic recalculation it is fine I can save it & reopen it & it does not occur. If I leave automatic recalculation stay clicked (on) it happens again after I fix this. I have used the sheet for years & it just started happening after the last update. I can delete the LO program on my Mac an download the program again tomorrow to see if that helps. Or, I can wait until the next update & see if it gets corrected then. Apparently the auto recalculate is setting cell protection on starting at the particular cell to the end of the column. I can copy the formula & paste it but it does not permanently fix the problem.
Thanks,
Deborah Bauer
[redacted]
LeroyG
February 19
Which error number is shown?
The file have private data? Can you share it, or a reduced sample file that show the problem?
Visit Topic or reply to this email to respond.
Previous Replies
DB3297
February 19
I had to turn off auto calculate in a l cal file I have been using for several years as the totals column kept being put into cell protection mode causing the column to show ERR. I tired resting the column to edit, saving the file as a new file, copying the file to another file & redoing the calculation field, nothing worked. This started happening right after updating to this version. The only way I could fix this was to turn off the autocalc on that column & force a recalculate hard to update the column each time.
Visit Topic or reply to this email to respond.
To unsubscribe from these emails, click here.
Okay, there is an error code, just brain dead here. ERR:522 which goes away if I uncheck autocalculate then recalculate. The autocaculte function seems to cause the error on all my spreadsheets.
Thanks,
Deborah Bauer
[redacted]
Hi @DB3297, ERR:522, it’s a circular reference, meaning the formula indirectly depends on its value.
Found this online & it fixed my problem I never turned this on or off so I am guess the last update unchecked this.
Fix: In LibreOffice, go to Tools > Options > LibreOffice Calc > Calculate and enable the option “Iterations“.
My formula is not recursive it is:
=IF(C36="","",G35+F36-E36)
1 Like