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@lists.freedesktop.org
Reporter: er...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs