[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 --- Comment #13 from johnks --- to add to this, if a protected sheet has a color prior to setting sheet protection, that color is shown even AFTER protection is applied -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 johnks changed: What|Removed |Added CC||testing1237...@yahoo.com --- Comment #12 from johnks --- Comment on attachment 162477 --> https://bugs.documentfoundation.org/attachment.cgi?id=162477 cell color of protected sheet i have attached a simple sheet showing this error on my calc password of the file is "asd" without the quotes the two sheets are identical but the second sheet is protected. visually sheet protection should NOT make a difference but it is on my instance and i remember this as far as i can recall. Version: 6.4.2.2 Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kf5; Locale: en-IN (en_IN.UTF-8); UI-Language: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 --- Comment #11 from johnks --- Created attachment 162477 --> https://bugs.documentfoundation.org/attachment.cgi?id=162477=edit cell color of protected sheet -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #10 from Heiko Tietze --- (In reply to ghaec...@gmail.com from comment #9) > I'll provide steps to illustrate how it works and where the documentation > is inadequate. Cool, thanks a lot. The next step in open source is to add/implement this yourself. Resistance is futile :-) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 Timur changed: What|Removed |Added Status|NEEDINFO|NEW -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 --- Comment #9 from ghaec...@gmail.com --- (In reply to Heiko Tietze from comment #8) > (In reply to ghaec...@gmail.com from comment #7) > > ...protecting the sheet (when Value highlighting is enabled) changes the > > background color of unprotected cells to white > > I cannot follow. Please provide step by step like > > 1. Insert a number in A1 > 2. Insert a formula in A2 > 3. Enable value highlighting (makes font color in a1 blue and a2 green) > 4. Enable sheet protection (changes the background into gray but should...?) Okay, I finally understand how value highlighting works. Since this issue has been changed to Documentation (NotABug), I'll provide steps to illustrate how it works and where the documentation is inadequate. I'll also offer suggestions on how to make value highlighting behavior more consistent and intuitive than it is now. Application Color abbreviations docFG - General/Font color docBG - General/Document background vhTextFG - Spreadsheet/Text vhValueFG - Spreadsheet/Values vhFormulaFG - Spreadsheet/Formulas vhProtectedBG - Spreadsheet/Protected cells background As it is now: 1. Select al cells and deselect the protected attribute 2. Insert text in A1 3. Insert a number in B1 4. Insert a formula in C1 5. In D1 set the protected attribute 6. Select the range, A1:D1, and set a user-defined background color like Light Yellow 3, which I'll just call userBG. All 4 cells show userBG and docFG, as expected. 7. Enable value highlighting - As expected, A1, B1, and C1 change foreground color from docFG to vhTextFG, vhValueFG, and vhFormulaFG, respectively. Oddly, however, none of the background colors are affected - all 4 cells still show userBG 8. Protect the sheet - As expected, foreground colors remain unchanged and correspond to the value highlighting colors. However, all 4 cells background colors are changed. D1 background changes from userBG to vhProtectedBG. Unexpected (and undocumented) is the background change in unprotected cells, A1:C1, from userBG to docBG. Current documentation for value highlighting states and value highlighting overrides user-defined colors. That's fine, but the application doesn't do it consistently. When value highlighting is enabled, the 3 configurable foreground colors (vhTextFG, vhValueFG, and vhFormulaFG) are applied whether the sheet is protected or not. The 2 configurable background colors for value highlighting are only applied when the sheet is protected. Moreover, one of the configurable background colors (docBG) is a global color, affecting all modules. Suggestion for more consistent/intuitive behavior: 1. When value highlighting is enabled, enforce all 5 related colors, whether or not the sheet is protected. The sheet doesn't have to be protected in order to know if a cell has the protected attribute. Sheet protection is about restricting access, not about display/formatting. 2. Add another configurable value highlighting color, "Unprotected cells background", so that it can be configured separately from the global docBG setting. In addition to providing more consistent behavior, these changes would also simply documenting the feature. It would just be a simple on/off toggle that overrides user-defined formatting. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 Heiko Tietze changed: What|Removed |Added Keywords||needsUXEval --- Comment #8 from Heiko Tietze --- (In reply to ghaec...@gmail.com from comment #7) > ...protecting the sheet (when Value highlighting is enabled) changes the > background color of unprotected cells to white I cannot follow. Please provide step by step like 1. Insert a number in A1 2. Insert a formula in A2 3. Enable value highlighting (makes font color in a1 blue and a2 green) 4. Enable sheet protection (changes the background into gray but should...?) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 Heiko Tietze changed: What|Removed |Added Status|NEW |NEEDINFO -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 --- Comment #7 from ghaec...@gmail.com --- If I may, here's an opinion related to Protected cells background: a) it would be helpful if this application color was in effect even before the sheet is protected (when Value Highlighting is enabled), and b) protecting the sheet (when Value highlighting is enabled) changes the background color of unprotected cells to white (why should protecting a sheet affect unprotected cells in any way at all?) In other words, protecting a sheet shouldn't affect any cell background color - it should just - uh - protect the sheet. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 129024] FORMATTING - Preset protected cell background color not displayed in spreadsheet (documentation per Comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=129024 Timur changed: What|Removed |Added CC||olivier.hallot@libreoffice. ||org Severity|normal |minor Priority|medium |low Summary|FORMATTING - Preset |FORMATTING - Preset |protected cell background |protected cell background |color not displayed in |color not displayed in |spreadsheet |spreadsheet (documentation ||per Comment 6) OS|Mac OS X (All) |All Component|Calc|Documentation --- Comment #6 from Timur --- Thanks ghaecker for finding the explaination. That's per Help https://help.libreoffice.org/6.5/en-US/text/scalc/01/0308.html. So that's as expected and bug is literally NotABug. But looking at this, I noticed that Help doesn't work for Tools - Options - LibreOffice - Application Colors. And I'll convert the bug as documentation for that. That can also go to the existing above-mentioned page. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
