Description: It doesn't need to be exactly that, but any indicator would be nice. I would like to be able to make part of the sheet constantly locked and quickly and obviously know it is locked. This is intended for a constantly updated log finance sheet. It would be terrible to accidentally edit historical data; however, I would like to keep adding new data and quickly be able to protect it. However, since I can't tell what is protected and unprotected just by looking at the sheet, it is scary. Right now, I try to use the record feature, but it still makes me nervous. I'm using the protection as a "read-only" sort of feature. I tried to use conditional formatting; however, I can only test against the protect setting and not the mode. This means it can indicate cells are "protected" if their "protect" setting is selected, but it ignores if the sheet itself is NOT in protected mode. This means I can still edit cells that are conditionally formatted as "protected". Actual Results: This is not a required field. Expected Results: This is not a required field. Reproducible: Always User Profile Reset: No Additional Info: This is not a required field.
Have you tried to create a style for protected cells with a different background color than the style used in non protected cells, then it's easy to apply the style to protect the cells.
(In reply to m.a.riosv from comment #1) > Have you tried to create a style for protected cells with a different > background color than the style used in non protected cells, then it's easy > to apply the style to protect the cells. Could you give me a concrete example on how to do this. I have never used a style, so I don't know if this accomplishes what I need.
Please take a look https://ask.libreoffice.org/en/question/71499/see-what-cells-are-protected-and-not/ how to do it.
(In reply to m.a.riosv from comment #3) > Please take a look > https://ask.libreoffice.org/en/question/71499/see-what-cells-are-protected- > and-not/ how to do it. Thank you. The bottom answer about the Value Highlighting is good enough for what I needed.