[Libreoffice-bugs] [Bug 139421] Calc: calcuate weeknumber-year missing in 2021

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jan 5 12:58:49 UTC 2021


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

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Regina Henschel from comment #3)
> I cannot confirm the initial reported results
> =TEXT(A1;"yyyy-WW") returns correctly the ISO week number
>   2020-53 for date 2020-12-31.

This depends on language selected in Format Cells->Numbers. For e.g. ru-RU or
en-US, this gives 2020-1. For de-DE, it returns 2020-53.

>   2021-53 for dates 2021-01-01, 2021-01-02, 2021-01-03

This is exactly what OP complains about: the week number 53 should be *of year
2020* for dates in the beginning of year 2021, if use de-DE; or week 1 of *year
2021* is needed for dates in the end of 2020 with en-US.

Note the "[YYYY] indicates the ISO week-numbering year which is slightly
different from the traditional Gregorian calendar year" in [1].

https://en.wikipedia.org/wiki/ISO_8601#Week_dates

-- 
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/20210105/5d0d0256/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list