Hi Libreoffice people,
I have the same issues today (Sep 16, 2020) as the old post below. I run version 22.214.171.124 (64bit). I have been trying to find a solution for days and nothing. It is a very very frustrating bug. Any permanent solution or at least a fix?
Thank you for any answer. Hopefully it’s not going to be closed as “not relevant or outdated”.
Posted on Sep 14, 2014. Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-03 17:58:13.438933.
"I have an ods file that I use to store translations
I have had a lot of problems with it over the years due to various bugs in Calc. One of those is that often times Calc will report that a cell is protected when I try to change a value (I never ever tried to protect the document, sheet or cell). In most cases, despite the annoying popup, it will actually change the value, a bug in itself, but in other cases it won’t allow me to change the value, which is worse, since I can’t turn it off.
When I go to format cell, it also reports that it can’t be formatted because it’s protected, but the protected checkbox is turned on. When I turn it off, I get the same message and when I get back to the Format Cells popup, it’s checked again.
Neither sheet or document is protected. I don’t want it, I don’t need it. How do I turn it off, rip it out, get rid of this bs?"
UPDATE: Here is the ods file:
Calc _ Unwanted automatic cell protection with bugs.ods
I am using W10, Home Edition, 64bit