https://bugs.documentfoundation.org/show_bug.cgi?id=147316
Bug ID: 147316
Summary: ODF NUMBERVALUE is too restrictive, disallowing to
treat datetimes in locale-independent way
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CC: er...@redhat.com
ODF defines NUMBERVALUE to only treat valid xsd:float [1]. This disallows e.g.
this:
=NUMBERVALUE("2022-02-09 13:50:25.1234";".";"")
which would allow to process datetime values with specified decimal separator
used for second fraction.
Note that Excel allows at least NUMBERVALUE("2022-02-09").
[1]
https://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#NUMBERVALUE
--
You are receiving this mail because:
You are the assignee for the bug.
