[Libreoffice-bugs] [Bug 139548] New: =WEEKNUM(xxx; 2) Returns Wrong Week Number for 2021

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139548
           Summary: =WEEKNUM(xxx;2) Returns Wrong Week Number for 2021
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mails.bugs.documentfoundation.org at gunter.ohrner.net

Description:
If I don't significantly misread all documentation I could find, WEEKNUM does
not work as documented for the year 2021:

https://help.libreoffice.org/7.0/en-US/text/scalc/01/func_weeknum.html?&DbPAR=WRITER&System=UNIX

System 2

> The week containing the first Thursday of the year is the first week of the
> year, and is numbered week 1. That means that week number 1 of any year is
> the week that contains January 4th. ISO 8601 defines this system and that the
> week starts on Monday.

However:

01.01.21        1       =KALENDERWOCHE(A1;2)
02.01.21        1       =KALENDERWOCHE(A2;2)
03.01.21        1       =KALENDERWOCHE(A3;2)
04.01.21        2       =KALENDERWOCHE(A4;2)
05.01.21        2       =KALENDERWOCHE(A5;2)
06.01.21        2       =KALENDERWOCHE(A6;2)
07.01.21        2       =KALENDERWOCHE(A7;2)


Steps to Reproduce:
1. Use the example data pasted to the description field


Actual Results:
The week containing the 4th of January is counted as "week 2".

Expected Results:
The week containing the 4th of January should be counted as "week 1". That's
what the documentation states, and also what my calendar says...


Reproducible: Always


User Profile Reset: No



Additional Info:
Reproducable in both
* 7.0.4.2 Linux 64 Bit desktop binary
* and LibreOffice 6.4 (Collabora CODE).

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