https://bugs.documentfoundation.org/show_bug.cgi?id=139421
--- Comment #5 from Regina Henschel <[email protected]> ---
(In reply to Mike Kaganski from comment #4)
> (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
Your are right. That means, that LibreOffice needs a new format string
"YYYY-Www" or "YYYYWww" to indicate the ISO way of calculating? Something for
Eike?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
