[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 13:39:13 UTC 2021


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

--- Comment #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Regina Henschel from comment #5)
> That means, that LibreOffice needs a new format string
> "YYYY-Www" or "YYYYWww" to indicate the ISO way of calculating?

I'd suggest something like "YW" (for "week-numbering year"), which is not yet
used in our number format codes [1].
Note that we should not limit us to "ISO way", because ISO week-numbering year
is just a special case of week-numbering year. But then, how to separate
"week-numbering year in current locale convention" from "ISO week-numbering
year", esp. if the format code has no other date parts that could hint that ISO
convention is used? ... so maybe two codes needed ... 

> Something for Eike?

... which is why I CCed him when I wrote in comment #1:

> Possibly another separate code is needed, like "calendar week year" or so?

[1] https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html

-- 
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/d6056d16/attachment.htm>


More information about the Libreoffice-bugs mailing list