Protected Cells are shown with grey background with "'Value Highlighting' active, what currently is not mentioned in Help. Current Help: "Text cells are formatted in black, formulas in green, and number cells in blue, no matter how their display is formatted." Should be "Text cells are formatted in black, formulas in green, number cells in blue, and Protected cells will bee shown with light grey background, no matter how their display is formatted." Help here never was complete, inherited from OOo!
@Spreadsheet Team Please do a final decision whether current behavior for protected cells is intended and correct (I think it is) amend Help if necessary. Additionally please close or proceed related Bug 47628
Yes, the current behavior of showing gray on protected cells is correct and intended. If the help doesn't mention this, then the help indeed needs to be amended.
Current WIKIHELP text (same as LOCALHELP)
Stanislav Horacek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=4ae80c49646df353bada547f4755593bf1a6b209 fdo#60875 add highlighting of protected cells 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.