https://bugs.documentfoundation.org/show_bug.cgi?id=33801
V Stuart Foote <vstuart.fo...@utsa.edu> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |vstuart.fo...@utsa.edu
--- Comment #16 from V Stuart Foote <vstuart.fo...@utsa.edu> ---
Created attachment 131854
--> https://bugs.documentfoundation.org/attachment.cgi?id=131854&action=edit
sample document with WEEKNUM in mode 21 (ISO 8601) -- adjust Locale to test
(In reply to seumas from comment #15)
> Actually, it was the other way around: weeknum() was giving the correct
> locale dependent week. The WW formatting was giving the incorrect week.
>
> I just tested with Version: 5.1.6.2. The good news is that both methods
> return the same week number. The bad news is that they are now *both*
> incorrect. Both return Week 7 for 07/02/2011 (7th February)
No Eike is correct, the WEEKNUM is hardcoded to the selected MODE. Locale has
no impact on the calculation.
https://help.libreoffice.org/Calc/WEEKNUM
But for English (UK) locale WW date formatting is not handled as a ISO 8601,
French (France) and German (Germany) locales both are. And, English/French
(Canada) has me scratching my head.
In the attached sample document I've set the WEEKNUM to mode 21 to force ISO
8601, simply change the Tools -> Options -> Languages Settings -> Languages:
Local setting to locale.
If the locale based English (UK) WW should be ISO 8601 it is not--and this
remains valid.
--
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
