[Libreoffice-bugs] [Bug 135246] New: LibreOffice Calc does not apply conditional formatting as expected

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 135246
           Summary: LibreOffice Calc does not apply conditional formatting
                    as expected
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: All
                OS: FreeBSD
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: byrnejb at harte-lyne.ca

Description:
Fields possessing both direct and conditional formating have the direct
formatting removed (neumeric / data / currency) and replaced with the default
format.  However the correct combined format is shown in the conditional format
dialogue box.

This is noted to occur erratically.  Some cells have the display format
reverted and others do not.

Steps to Reproduce:
1. Open new sheet
2. Apply direct formatting to cell (date 2001-01-01)
3. Input new value in Cell
4. Apply negative warning conditional format to cell
5. Satisfy condition
6. Cell value changes from 2001-01-01 to 36892.00

Actual Results:
Cell displays 36892.00 in white on red background

Expected Results:
Cell should display 2001-01-01 in white on red background


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Not all conditionally formatted cells display this behaviour even when the same
conditions and conditional format applies.

-- 
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/20200728/12b5ad56/attachment.htm>