[Libreoffice-bugs] [Bug 131524] Date format in a cell with conditional formatting turns to money

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=11
                   |                            |7715
                 CC|                            |erack at redhat.com
             Blocks|                            |87351
             Status|UNCONFIRMED                 |NEW

--- Comment #5 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
reproducible with:

Version: 6.3.5.2 (x64)
Build-ID: dd0751754f11728f69b42ee2af66670068624673
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

but *not* reproducible with:
Version: 6.2.8.2 (x64)
Build-ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

setting to "NEW" but I think, this issue is a duplicate of:
Bug 117715 - Settings from Conditional formatting should overwrite direct
formatting

cause cell F3 has a hard cell number format: DD.MM.YY
and conditional format: 
apply cell style "zapłacone" if $I3=0
-> number format: [$£-809]#.##0,00;-[$£-809]#.##0,00
-> background:    green

with $I3=0
LO 6.2.8.2: green background and DD.MM.YY
LO 6.3.5.2: green background and £

https://bugs.documentfoundation.org/show_bug.cgi?id=117715#c12
> So the only solution for consistency seems to be to effectively 
> revert the fix for 93300 and have all conditional formatting take precedence. 
> This might be what the majority expects


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
-- 
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/20200329/c5702715/attachment.htm>