[Libreoffice-bugs] [Bug 131114] number / date format display error after formula

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de
            Summary|erreur d'affichage de       |number / date format
                   |format nombre/date après    |display error after formula
                   |une formule                 |

--- Comment #1 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
Description:
Since update 6.3.5, I have a display bug:
I have a cell with calculations to give a number of days, and I have a display
in "date" that I cannot modify.
works normally up to version 6.3.4.1

Steps to Reproduce:
1.cell E266 = 1/31/20
2.cell O266 = IF (E266 = ""; - 1; IF (F266 = ""; IF (G266 = ""; DAYS (TODAY ();
E266); DAYS (TODAY (); G266)); 0) )
3.

Actual Results:
02/01/00

Expected Results:
33


Reproducible: Always


User Profile Reset: No

Additional Info:
on older versions (6.3.0.4) the current result is obtained by applying the date
format.
problem also present on version 6.4

-- 
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/20200306/d854eafd/attachment.htm>