[Libreoffice-bugs] [Bug 132106] New: 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

            Bug ID: 132106
           Summary: CELL() function "format" should include more date
                    formats to return "D1"
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: erack at redhat.com

The CELL() function for argument "format" lacks at least the ISO 8601
YYYY-MM-DD date format to return "D1" (and for other formats including day,
month and year format codes).

Probably YYYY-MM-DD HH:MM:SS and other full date+time formats should return
"D4", though there is no "and similar formats" mentioned like for D1 in the
ODFF spec.

See
https://help.libreoffice.org/6.4/en-GB/text/scalc/01/04060104.html?DbPAR=CALC#bm_id3155509
and
https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CELL

-- 
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/20200414/3f9ccf46/attachment.htm>