Description: If a cell range has a conditional format and an entry on it triggers the conditional format it immediately becomes "protected" so one can't edit its value if wrong. Any attempt returns the warning "Protect cells can not be modified." I'm attaching a three column sample. Columns A and B have conditional formating indicating the maximum and minimum value of the column range. These columns ARE NOT write protected. The C column has a simple formula calculating the difference of A minus B. This column IS write protected. As far as I know this problem appears on LibreOffice versions 6.2.2 to 6.3.3. Actual Results: Introduce values on columns A and B Expected Results: The difference A - B will show on C Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes
Created attachment 156418 [details] Conditional format bug sample
I can not find a mistake: cell A2 (value: 30) uses cell style "BlueBack" "BlueBack" has cell protection enabled -> if sheeet is protected, A2 is not editable. cell A19 (value: 20) uses cell style "RedBack" "RedBack" has no cell protection -> A19 is always editable Can you please check?
(In reply to Oliver Brinzing from comment #2) > I can not find a mistake: > > cell A2 (value: 30) uses cell style "BlueBack" > "BlueBack" has cell protection enabled > -> if sheeet is protected, A2 is not editable. > > cell A19 (value: 20) uses cell style "RedBack" > "RedBack" has no cell protection > -> A19 is always editable > > Can you please check? Thanks for your reply, Oliver. This "cell protection enabled" was my first concern. I did check both styles properties (F11) before reporting but couldn't find any reference to cell protection there. Am I missing something? Both styles (RedBack and BlueBack) were equally made except by the different background color. Sorry for the bogus alert.
(In reply to Euler German from comment #3) > (In reply to Oliver Brinzing from comment #2) > > I can not find a mistake: > > > > cell A2 (value: 30) uses cell style "BlueBack" > > "BlueBack" has cell protection enabled > > -> if sheeet is protected, A2 is not editable. > > Thanks for your reply, Oliver. > This "cell protection enabled" was my first concern. I did check both > styles properties (F11) before reporting but couldn't find any reference to > cell protection there. Am I missing something? Never mind, I just found the way to reset the "protect cell" to "un-protect". When using "F11 > Properties" and clicking "More options" button, the Cell Protection tab always shows style as Un-protect. OTOH right-clicking the style in the styles' list, and picking Modify from the menu opened the right dialog.
[Automated Action] NeedInfo-To-Unconfirmed
> OTOH right-clicking the style in the styles' list, and picking Modify > from the menu opened the right dialog yes, you need to change the cell style to "unprotect" to make it work