[Libreoffice-bugs] [Bug 36175] Cells keep date autoformat incorrectly

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #18 from Eike Rathke <erack at redhat.com> ---
If one enters a formula, pre-existing formatting will not be discarded unless
it was Boolean. The reason is that internally date+time is only a date serial
number and any number can be formatted as date+time (value in days since null
date, so 0.5 == 12 hours). In case of =4/5 the actual value 0.8 formatted as
date+time is 1899-12-30 19:12:00

We maybe could check if the final result of a calculation of a newly entered
formula expression could actually be a date and remove a date format if not,
but that somehow sounds like overkill and again could be error prone and wrong
in cases where some numeric calculation is done and the user actually wanted
the result be formatted as date.

Fwiw, Excel behaves the same and keeps the date format.

-- 
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/20170825/8767cacd/attachment.html>