[Libreoffice-bugs] [Bug 136050] Calc changes the cell type from time to date when the format-code is changed

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

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

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
A single MM format code is month of year, not minutes, and displays the
underlying cell value accordingly. This is not a bug and will not be changed.
There is no time type or date type cell. A date or time or date+time is just a
floating point number, days since null date, where 0.5 is 12 hours, the time
00:19 with 0 days since null date formatted as date happens to be 1899-12-31 so
the result for MM is 12.

You can use the format code [MM] to format a duration in minutes only.

-- 
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/20200825/b34422b8/attachment-0001.htm>