How can I use conditional formatting to protect a cell in LibreOffice Calc?
Or do you have another method to produce this effect in LibreOffice Calc 18.104.22.168 in Windows 10?
Here’s an example:
Type 1: 10 12 14
Type 2: 8 2 8
Type 3: 10 5 15
Protect: 1 1 0
I would like to use conditional formatting so that when a “1” is typed into the Protect line, all cells of that column (including the cell to Protect column itself) changes status to Protected. That would be programmed into each cell’s conditional formatting.
I can change the color of a cell with conditional formatting, but so far I am unable to force it to become protected by some automated method.
The goal is for a user to type values, and once the user is certain that the values are ok, he can lock all cells of that column with a single keystroke. That prevents accidental modification of that column later on. The lock also applies to the last line, so the user cannot remove its own lock once it has been activated.
I would also need the reverse idea: if a 0 is typed into the Protect line, all cells of that column become unprotected. That would only be doable by a user with the protected sheet password, so it would still be ok.
I am using the French version of LibreOffice, but I posted in English because I thought I would get more replies.