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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Peter S Anderson <peter at pza.net.au> ---
Created attachment 168700
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168700&action=edit
Spreadsheet showing incorrect values of Weeknum

I have confirmed this bug in 6.4.7.2 and DEV although the results given in the
initial bug report are incorrect.

The bug notes that the text formatting function,

text(date-value, “WW”) is giving the incorrect result for the date 31/12/2020.

My reference documentation is  

https://help.libreoffice.org/3.3/Calc/WEEKNUM

Here it states that week number 1 of any year is the week that contains January
4th.

The problem is that Jan 4 2020 was a Saturday and so Jan 5 2020 was the start
of week 2 of 2020 and week 53 starts on Dec 27 and ends on Jan 2. Week 1 of
2021 starts on Jan 3, 

I have attached a spreadsheet that shows that there is a problem with both the
Weeknum function and the WW format from Dec 27 2020 and probably for most of
2021.

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