[Libreoffice-ux-advise] [Bug 143100] Disable cell style commands and sidebar when sheet is protected

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143100

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Add an error message "You   |Disable cell style commands
                   |can't change any cell       |and sidebar when sheet is
                   |styles. You have a          |protected
                   |protected sheet in your     |
                   |spreadsheet now"            |
             Status|UNCONFIRMED                 |NEW
             Blocks|34694                       |107332
           Keywords|needsUXEval                 |difficultyMedium, easyHack,
                   |                            |skillCpp, topicUI
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org
     Ever confirmed|0                           |1

--- Comment #1 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
You cannot apply a Cell Style to protected sheets, neither per content menu >
Styles nor the main menu > Styles or the sidebar via deck Styles. In all cases
the messagebox shows up "Protected sheets can not be modified".

In addition, it's not possible to modify the styles - otherwise you could turn
red cells into green. And this fails silently.

However, I don't think the way to go is to pretend it works but show a message
box telling the opposite. We should rather disable the Styles commands and the
sidebar deck content if the sheet is protected.

Code pointer might be ScFormatShell::GetStyleState() in
sc/source/ui/view/formatsh.cxx (but not sure).


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=34694
[Bug 34694] [META] Improve usability of error messages
https://bugs.documentfoundation.org/show_bug.cgi?id=107332
[Bug 107332] [META] Calc cell and page styles bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.