[Libreoffice-bugs] [Bug 132106] CELL() function "format" should include more date formats to return "D1"

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
What an utter mess..

So, ODFF in
https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CELL
tried to follow
https://support.office.com/en-US/article/CELL-function-51BD39A5-F338-4DBE-A33F-955D67C2B2CF
(or an older version thereof) but got one example for D1 wrong, namely MM-D-YY
should not be there and the "and similar formats" is misleading in that
context.

Inspecting the MS-Excel examples (d-mmm-yy or dd-mmm-yy) I deduce that only
date formats containing all three DMY and using an abbreviated month name
should return D1. The long month names MMMM are nowhere mentioned. Maybe it's
also even only for those en-US D-MMM-YY formats, which are contrary to the
"normal" en-US MDY order, as the examples (m/d/yy or m/d/yy h:mm or mm/dd/yy)
for D4 are all en-US centric. I tried to compare with the German page
https://support.office.com/de-de/article/zelle-funktion-51bd39a5-f338-4dbe-a33f-955d67c2b2cf
but that stupidly lists the same formats just with the localized format code
keywords.

Seeing D4 (m/d/yy or m/d/yy h:mm or mm/dd/yy) I'd say that *all* formats using
all three DMY numeric in any order with or without time should be D4, so also
YYYY-MM-DD or YYYY-MM-DD HH:MM and the like.

-- 
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/20200416/713b7f14/attachment.htm>