[Libreoffice-bugs] [Bug 91405] calc does not save explicitly defined cell formatting for date functions
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Sep 30 17:09:30 UTC 2017
https://bugs.documentfoundation.org/show_bug.cgi?id=91405
Eike Rathke <erack at redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WONTFIX
--- Comment #8 from Eike Rathke <erack at redhat.com> ---
For cells that are formatted to the standard (non-fixed) General number format
a date format is applied when a function is calculated that returns a date/time
result. TODAY() and NOW() are always recalculated, hence a format is applied.
This won't be changed. Use an explicit number format instead of the General
format, or if the automatic decimals are wanted define a format of
General;General which also creates a new fixed non-standard 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/20170930/782cc3b2/attachment.html>
More information about the Libreoffice-bugs
mailing list