Created attachment 72208 [details] Examle issue in sheet LO Version 4.0.0.0.beta2+ (Build ID: c5229f497008051b078e9f76e00031dfb3b6f41) Windows 7 64 bits I have do the next: 1) open sheet attachment 2) in cell c9 is coditional formatting used 3) when in cell A1=1 the conditional format is correct 4) when in cell A1=2 the cell c9 is protect, but must didn't protect 5) when unprotect the sheet -> see cell c9=unprotect menu-format-cells-cell Protection In LO 3.6.4 is cell unprotect oke, but in the conditional formatting is the protect cells not correct.
I fixed the bug that conditional formats don't respect sheet protection and additionally fixed that specifying cell protection in conditional format styles had no effect. So now conditional formats also affect cell protection.
What i mean is that: 1) When there is conditional formatting in a cell, but the cell is in the format unprotected, even so the cell become protected in cell ("c9"). This is wrong and by my a bug. 2) When in conditional formatting is use cell protection, this had no effect. -> This is also be present 3.6.4 and not a bug. I have check in LO Version 4.0.0.0.beta2+ (Build ID: afa240330b51fb3607cfa6390aeb4e085cd1c52) and also present. Can you tell me if this is solved?
marking as NEW as Marcus has said it is confirmed
confirm in LO Versie 4.0.0.2 .0.2 (Bouw-id: 5991f37846fc3763493029c4958b57282c2597e) windows 7 64 bits
Hi, I reproduce with rc2: Version 4.0.0.2 .0.2 (Build ID: 5991f37846fc3763493029c4958b57282c2597e) - Vista The behaviour is as follows: 1 / When the condition is satisfied, the style is applied with respect for the choice protected / unprotected (that's ok) 2 / Otherwise, the cell is always protected regardless of the style applied Critical => this bug forbids to use previous spreadsheets where conditional formatting are applied on cells where you have to enter values ! A lot of users will be concerned
@ Michel Rudelle, Thanks for your attention and this is very boring! I hope it can solved.
While I disagree with this being a critical bug (no crash, no memory eat up, etc...) which is usually a pre-condition for such a high priority...I hope Markus can take a look at this one soon. Markus -- can we assign you to this one?
*** Bug 59968 has been marked as a duplicate of this bug. ***
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5e29af062de877476f5382e8d7368c3de4409b47 if no cond format is valid use the existing protection, fdo#58826 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.
*** Bug 59289 has been marked as a duplicate of this bug. ***
I have test in master LO Version 4.1.0.0.alpha0+ (Build ID: 027bb41aa16793e88e9fc1b3550c8c893363647). The bug is solved and works correct now. Thanks for the attention and i hope it can be solved for LO 4.0.0
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7c6b21c31904b2ed007f961e4bf094af1a1981c7&h=libreoffice-4-0 if no cond format is valid use the existing protection, fdo#58826 It will be available in LibreOffice 4.0.1. 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.
*** Bug 60897 has been marked as a duplicate of this bug. ***
*** Bug 61048 has been marked as a duplicate of this bug. ***
Verified with: Version 4.0.1.1 (Build ID: 2c0c17a6e4bee0ee28131ea4bdc47edc700d659) - Vista-32b It's ok Thanks
Verified that it's ok and solved on: Version 4.0.1.1 (.deb 64bits) Build ID: 2c0c17a6e4bee0ee28131ea4bdc47edc700d659 S.O: Linux Mint14 64bits Thanks for your great work Markus! David.