Protection of a sheet prevents conditional formatting changes, but some operations do nothing instead of displaying an error message.
Steps to reproduce:
1. Create a new document.
2. Click above "1", left of "A" to select all cells.
3. Open Format/Cells.../Cell Protection
4. Uncheck "Protected".
5. Click "OK".
6. Open Tools/Protect Document/Sheet...
7. Click "OK".
8. Try to open Format/Conditional Formatting/Condition..., /Color Scale..., or /Data Bar...
9. Open Format/Conditional Formatting/Manage...
8. Nothing happens: no conditional formatting box, no message.
9. A message box with the message: Conditional Formats can not be created, deleted or changed in protected sheets!
8. A message box appears explaining that conditional formatting is not allowed in protected sheets, even for protected cells.
9. Replace the "!" at the end with "even for unprotected cells.". No need for an exclamation mark, and the extra words would help clarify that the situation is not an error.
Note: This is based on the response to bug 60837. Any menu items ending with "..." should elicit a response from the program.
Version 220.127.116.11.alpha0+ (Build ID: b8e0455f201198b1deb8f8ca0181e6c9cadc335)
Date: Sat Feb 23 16:04:37 2013 -0600
Bodhi Linux 2.2
Minor (doesn't prevent high quality work but is a bit confusing, if a user has taken steps to protect a sheet they probably know why they can't change formatting)
Medium (relatively easy to fix, inconsistent)
CC'ing Markus since he handles the Conditional Formatting stuff.
Reproducible with LO 18.104.22.168, Win 8.1
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.0.5 or 5.1.0) https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2016-02-21
The problem still exists. Tested with version 22.214.171.124 on Windows 7.
The bug behavior isn't changed. I tested Formatting/Condition... and Formatting/Manage...
The setup instructions are slightly different. Step 6 should be:
6. Open Tools/Protect Sheet...
(In reply to Joel Madero from comment #1)
> Version 126.96.36.199.alpha0+ (Build ID: b8e0455f201198b1deb8f8ca0181e6c9cadc335)
> Date: Sat Feb 23 16:04:37 2013 -0600
> Bodhi Linux 2.2
> New (confirmed)
> Minor (doesn't prevent high quality work but is a bit confusing, if a user
> has taken steps to protect a sheet they probably know why they can't change
> Medium (relatively easy to fix, inconsistent)
> CC'ing Markus since he handles the Conditional Formatting stuff.
I disagree with the reasoning for the "Minor" designation.
Here's how I discovered this: I had a cell which was accidentally being damaged. So I set up protection on the sheet and disabled protection on everything but that one cell.
I had no reason to expect I couldn't change formatting on cells other than the one protected cell. The lack of any feedback when I tried to change formatting was very frustrating.
(Not I'm just disagreeing with the reasoning. I haven't studied your categorization of bugs and the level may still be appropriate.)
> > CC'ing Markus since he handles the Conditional Formatting stuff.
> I disagree with the reasoning for the "Minor" designation.
First, thanks for taking the time to respond.
Second, just a heads up that the severity/priority almost has *no* impact on if the bug is actually fixed or when it is fixed. It's a volunteer project, lots of developers have "niche" areas that they focus on and couldn't care less whether it's a critical bug or a trivial bug, they just want that area working. The severity/priority is just objective standard (I explained what a minor bug is, slows down but doesn't prevent high quality work).
Solved by https://gerrit.libreoffice.org/#/c/47395/
Gulsah Kose committed a patch related to this issue.
It has been pushed to "master":
tdf#61418 Show message on protected sheets for conditional formatting.
It will be available in 6.1.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.