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

[bugzilla-daemon]

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

Laurent BP  changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 Status|NEW |RESOLVED

--- Comment #14 from Laurent BP  ---
(In reply to vlb from comment #13)
> I have change the func and it works now!
> Thanks for help here to solve it.
As it seems solved, I close this report. Feel free to reopen it if necessary.

-- 
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

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

[bugzilla-daemon]

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

--- Comment #13 from vlb  ---
(In reply to Eike Rathke from comment #12)
> 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- or -MM-DD date format and UU:MM time
>format

I have change the func and it works now!
Thanks for help here to solve it.

-- 
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

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

[bugzilla-daemon]

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

--- Comment #12 from Eike Rathke  ---
With 6.0.2.1 in an en-US locale I do not even get the mentioned error with the
default "-MM-TT" format, just the date is displayed as -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-" or "-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- or -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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #11 from Laurent BP  ---
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 -MM-DD (-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 -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 -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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

   Keywords|bibisectRequest |bibisected, bisected
 CC||er...@redhat.com,
   ||jumbo4...@yahoo.fr
   Hardware|x86-64 (AMD64)  |All
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=33
   ||689
Summary|EDITING, used extension |Datetime2 extension gives
   |Datetime2 give error in LO  |error in LO 6.0.0.3
   |6.0.0.3 |(locale-dependent)

--- Comment #10 from Aron Budea  ---
Bibisected to the commit referenced below using repo bibisect-win32-6.0. This
seems to be a fallout from bug 33689 fix.
Adding Cc: to Laurent BP, please take a look. Eike, also CCing you, since you
worked on another similar regression before (bug 114185).

https://cgit.freedesktop.org/libreoffice/core/commit/?id=80c0a7300b9e185cd77f754abbad31422826662c
author  Laurent BP    
2017-10-08 20:05:34 +0200
committer   Eike Rathke   2017-10-19 22:13:44 +0200

tdf#33689 Accept English syntax keywords in format strings

-- 
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