[Solved] Set cell protection in conditional format

Discuss the spreadsheet application
Post Reply
giuvi
Posts: 33
Joined: Sun Dec 21, 2008 12:29 am

[Solved] Set cell protection in conditional format

Post by giuvi »

Hello community!

I'd like to change the protection status of certain cells via conditional formatting depending on the value of another one cell. But as an old thread (viewtopic.php?t=3739&hilit=conditional+format) it would be not possible in AOOcalc.

Is it true yet, in the last AOO version?

Actually, I've obviously tested that and it does not run. But I want to be sure I did not make a mistake.

I use AOO 4.1.7 on OpenSuse 15.4
Last edited by MrProgrammer on Thu Jan 04, 2024 7:11 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] Use LibreOffice if you need this feature -- MrProgrammer, forum moderator
AOO 4.1.15 on openSUSE Leap 15.5
User avatar
Zizi64
Volunteer
Posts: 11364
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: change cell protection status via conditional formatting

Post by Zizi64 »

It works in my LibreOffice 7.5.8 and with ODF 1.3 extended file format:
CF_Protection.ods
(10.22 KiB) Downloaded 163 times
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply