[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 #11 from Laurent BP <jumbo4444 at yahoo.fr> ---
I cannot reproduce with:
- Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; 
Locale : de-DE (fr_FR); Calc: CL

My detailed procedure:
1. Install extension
https://github.com/komma4/DateTime2/blob/master/DateTime2.oxt and restart
2. Set German locale as it seems this macro works *only* for this locale (if
you use a different locale, you need to modify the code inside the macro as
explained in the description of the extension): Tools>Options> Language
Settings> Language> Locale setting = German (Germany)
3. Create a new spreadsheet
4. Tools > Macros > Run Macro > LibreOffice Macros > DateTime2 > DateTime2
5. Select Datum_Feld macro and click Run button

Actual behavior:
date is formatted YYYY-MM-DD (JJJJ-MM-TT with de locale)
I don't know if it is the expected behavior but I got no error message.

If I use a different locale than German, then the behavior will depend on
version and locale:
- With LibO6.0 there is an error message
- With previous version, LibO try to apply JJJJ-MM-TT number format in the
locale setting, and transform in text what is not recognized. For instance in
Dutch J is year, but T means nothing, so format will result in YYYY-MM-"TT"

>From my point of view there is an enhancement to warn user that macro does not
work as expected.

-- 
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/5ad7e8b1/attachment.html>