Apache OpenOffice (AOO) Bugzilla – Issue 28986
pressing BACKSPACE on a protected cell does not show the message that protected cells cannot be changed
Last modified: 2017-05-20 10:45:35 UTC
Please ... -open a new spreadsheet - enter anything into a cell - protected the sheet from changes - selecte the filled cell - press BACKSPACE: Nothing happens! Her you should show the message that protected cells cannot be changed, like when pressing ESC for example. (You may also have a look at issue 26965.)
typing error: "Her"->"Here"
Hi Niklas, one for you. Frank
Backspace (Delete Contents) is a configured slot that's disabled for protected cells. Generally in that case, the function isn't executed, so it can't show an error message.
"like when pressing ESC for example" -> "like when pressing DEL for example" "Generally in that case, the function isn't executed" This is a programming technical problem. But from the users point of view this is a bug. Excel shows such a message..
You may also have a look at issue 26965.
Bug was replicated using Mac OS X version 10.9 and Open Office 4.0.1 Build 9714. The steps necessary to replicate the bug are as follow: 1)Launch OpenOffice 2)Create a Spreadsheet document 3)Type something in a cell 4)Choose Tools->Protect Document->Sheet... 5)Choose a password 6)Press Ok. Sheet should be password-protected. 7)You can now choose your cell and press BACKSPACE 8)No alert is given Hope this helps, Jose Miranda 11/14/13
Reset the assignee to the default "issues@openoffice.apache.org".