[Libreoffice-bugs] [Bug 139342] New: LibreOffice counts weeknumbers wrong, starting in 2021...

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139342
           Summary: LibreOffice counts weeknumbers wrong, starting in
                    2021...
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Marceaux at zonnet.nl

Description:
When using a formula for counting the week numbers, LibreOffice counts it
wrong. The reason is because 2020 has 53 weeks instead of 52. LibreOffice Calc
doesn't recognize week 53, so it starts counting at week 1, starting this
coming year 2021. The result of it is that LibreOffice will be one week behind
in counting weeks.

The attachement shows what I mean...

Steps to Reproduce:
1. Open a Calc document
2. Use the formula for counting week numbers (don't know the name of that
formula in English
3. See that the weeknumber will be one week behind, starting in 2021

Actual Results:
Week 1 - 2021 instead of week 53 - 2020, and so on starting from the last week
of 2020....

Expected Results:



Reproducible: Always


User Profile Reset: Yes



Additional Info:
Recognize week 53 to make the week numbering correct again.

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