[Libreoffice-bugs] [Bug 137062] New: VIEWING Cells with conditional formatting by formula not automatically updated after change of source value

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137062

            Bug ID: 137062
           Summary: VIEWING Cells with conditional formatting by formula
                    not automatically updated after change of source value
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Stefan_Lange_KA at T-Online.de

Created attachment 165877
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165877&action=edit
zip file with document to show the problem and screenshots

Conditional formatting by formula is (occasionally?) not applied correctly,
means not immediately after a change of source value, but later e.g. when the
document is saved.
Steps to reproduce the bug: 
- open "Test_Formula_(Blood_pressure).ods" from the attached zip file
Values in columns A and B (Date and time) have a conditional formatting by
formula that the font and background color are changed to green resp.
lightgreen when at least one of the values in columns F, J and N is less than
100. Values in these 3 columns are computed by formula depending on values in
columns C+D, G+H resp. K+L.
- change value in cell L10 from 86 to 90 -> value in cell N10 automatically
changes from 99 to 102
- result: cells A10 and B10 remain unchanged although the condition for
conditional formatting is false, see screenshots 1 and 2
- save the document (or edit cell A10 or B10 e.g. by PF2 + exit without changes
e.g. by Enter key), see screenshot 3
- result: font and background colors of cells A10 and B10 are changed now
correctly (Standard, no background color)

First I have assumed the behavior described above is related to the behavior
described in Bug 137060. But it can be reproduced also with older versions of
LibreOffice back until 3.3.0, means the bug is inherited from OpenOffice.

-- 
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/20200926/de287610/attachment.htm>