https://bugs.freedesktop.org/show_bug.cgi?id=61525
--- Comment #9 from Rolf Eder <[email protected]> --- Sorry, my sample document was too simple. You are right, it works as expected. I will upload a new example that will demonstrate a locked (not selectable) but unprotected cell in a protected sheet. In fact there are more parameters active - e. g. the cells have conditional formatting: 1) marking the status protected/unprotected (for usability reasons: only the cells with no background fill are selectable). 2) in cells with content "0" the zero will be colored white (making it invisible, further enhancing readability). Remove conditional formatting #2 and everything is fine. You can select the cells with content "0" and enter other values. This example is an excerpt from a real life file. We have dozen other files of that kind need every day that prevent us rolling out LibO 4.x. This kind of formatting originates from MS Excel files (no problem there), but were saved in OpenDocument format long ago (sometime during the OOo 2.x days). You can select the zeroed cells in LibO 3.6.x and before but not in 4.x -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
