[Libreoffice-bugs] [Bug 122907] New: FORMATTING Style not correctly applied at conditional formatting

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122907
           Summary: FORMATTING Style not correctly applied at conditional
                    formatting
           Product: LibreOffice
           Version: 5.1.2.2 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 148570
  --> https://bugs.documentfoundation.org/attachment.cgi?id=148570&action=edit
Test document to demonstrate the bug

Styles with at least date formatting are not correctly resp. completely applied
at conditional formatting:
- font, alignment and background color are applied
- date format is not applied

To demonstrate the bug I have attached the document
"Test_bedingte_Formatierung_Format_Datum.ods".

In the cells of column A I have entered two date values (01.01.1958 and
02.01.1958) and one text ("kein Datum").
For the cells is defined a conditional formatting with 3 conditions:
1. When day and month both are 1, only the year should be dislayed (style
defined: Datum_jjjj).
2. When day and month not both are 1, the date should be dislayed as dd.mm.yyyy
(style defined: Datum_tt-mm-jjjj).
3. When an error occurs also style Datum_tt-mm-jjjj should be applied.

Expected result (as shown in column C - styles appled without conditional
formatting):
- The date 01.01.1958 should be displayed as 1958.
- The date 02.01.1958 should be displayed as 02.01.1958.
- The text "kein Datum" should be displayed as "kein Datum".

Actual results with LO from 3.3 until 5.1.1.3: as expected -> OK
Actual results with LO from 5.1.2.2 until 6.2.0 rc2, LOdev 6.2.1 and 6.3.0
alphy: the date format from style is ignored and both dates are dsplayed in a
default format, e.g. dd.mm.yy.

-- 
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/20190123/9a40e9c4/attachment.html>