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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 30 16:19:13 UTC 2020


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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
The style 'zapłacone' that is applied in the conditional format has the number
format set to
[$£-809]#,##0.00;-[$£-809]#,##0.00
so that is exactly what is applied. There's nothing wrong.
To apply a date format instead, create a style inherited from 'zapłacone' (to
inherit for example the green background) and set the desired date format, then
in the conditional format manager remove the column F ranges from the currently
applied ranges for style 'zapłacone' and create a new conditional format with
the same formula that applies the newly created style for dates to column F
ranges.

-- 
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/20200330/c5a2f252/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list