[Libreoffice-bugs] [Bug 129283] New: Cells with conditional formatting are treat as protected cells

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: efgerman at yahoo.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191208/a9120bcb/attachment-0001.html>