https://bugs.documentfoundation.org/show_bug.cgi?id=129283
Bug ID: 129283
Summary: Cells with conditional formatting are treat as
protected cells
Product: LibreOffice
Version: 3.3.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
