https://bugs.documentfoundation.org/show_bug.cgi?id=149950
Bug ID: 149950
Summary: datevalue function doesn't recognise month name in
EN-ZA
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
The datevalue function does not honour the data formats set in the Date
Acceptance Patterns setting.
This is best explained by show the following examples:
datevalue("02 Mar 2020) returns "Err:502"
datevalue("02 03 2020") returns "43892", which is correct.
>From the above examples, it appears as if there is only a problem with
recognising the month name abbreviation, but there's more to it.
My language setting is "English (South Africa)" and the default data
recognition strings are "Y-M-D;Y/M/D;M-D;M/D". This does not include "D M Y",
but LibreOffice seems to recognise the format anyway. This is nonsensical,
since the patterns are explicitly showing what will be recognised and not
recognising other formats not listed. I expect to have to add "M D Y" to that
string to make it "Y-M-D;Y/M/D;M-D;M/D;D M Y".
As an aside: I do understand that the official format for South Africa is the
default ""Y-M-D;Y/M/D;M-D;M/D", but that is not what is actually being used.
"dd mmm yyyy" is probably the most used format here. By comparison, the US is
supposed to us metric measurement (officially), but they don't, and LibreOffice
honours that. There doesn't seem to be a way for a user to fix the recognition
strings.
If I change the language to English (USA) or English (UK), it makes no
difference. The date recognition patterns are even less and still "D M Y" is
recognised and "Mar" not. Actually no month name is recognised.
This is not correct and it seriously affects usability as well as compatibility
with other formats like Excel for example. In Excel the above is interpreted
correctly, but when a sheet is imported into LO abd the values recalculated, it
gives the error 502.
--
You are receiving this mail because:
You are the assignee for the bug.
