I wished to protect some cells of my sheet. I did the documented steps
… IMO quite cumbersome and counter intuitive:
- unprotect all cells -which are by default “protected” (!)
- set the desired cells as protected… via the “Cell format” (!)
- set the sheet as protected
(all this, mind you, to protect a single cell)
Now, the sheet had a chart. After doing the above, the chart cannot be activated, selected or even moved. IF one clicks over it, all happens as if the chart didn’t exist: the underying cell is selected, one can edit it, etc.
This feels wrong, and I actually spent some time clicking as an idiot over the chart, before remebering that the sheet was “protected” and discovering that this was the cause.
Is this the expected behaviour?
I’m using LO 188.8.131.52, Windows-7.