[Libreoffice-bugs] [Bug 115528] Datetime2 extension gives error in LO 6.0.0.3 ( locale-dependent)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from Eike Rathke <erack at redhat.com> ---
With 6.0.2.1 in an en-US locale I do not even get the mentioned error with the
default "JJJJ-MM-TT" format, just the date is displayed as JJJJ-03-TT, which is
logical. In an nl-NL locale I get the error. This is because MYTIMEFORMAT is
"HH:MM" but in nl-NL should be "UU:MM". It works well if date format codes are
set to "DD-MM-JJJJ" or "JJJJ-MM-DD" and time format codes set to "UU:MM" to
match the nl-NL locale.

Original submitter should
a) in the macro module DateTime2_func change the MYDATEFORMAT,
   MYTIMEFORMAT and MYTIMESTAMPFORMAT to proper format codes matching
   the current work locale, as the extension explains; for nl-NL that
   would be the DD-MM-JJJJ or JJJJ-MM-DD date format and UU:MM time
   format
b) at least in Calc maybe rather use the Ctrl+; and Shift+Ctrl+;
   shortcuts to insert date and time values (note that for other UI
   languages' keyboards the shortcuts may differ)

Not sure at the moment why HH:MM is not accepted instead of UU:MM or if it
really should, it is accepted in the UI number formatter dialog and properly
converted to UU:MM

-- 
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/20180315/f66bc140/attachment-0001.html>