[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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de

--- Comment #3 from Regina Henschel <rb.henschel at t-online.de> ---
The function WEEKNUM has a second parameter to determine the mode of
calculation. It defaults to 1, which is not the ISO way. To get the ISO
calculation you have to use parameter 21. Or you use function ISOWEEKNUM.
Please read help for WEEKNUM and ISOWEEKNUM of a current release.

I cannot confirm the initial reported results
=TEXT(A1;"yyyy-WW") returns correctly the ISO week number
  2020-53 for date 2020-12-31.
  2021-53 for dates 2021-01-01, 2021-01-02, 2021-01-03
  2021-1  for dates 2021-01-04 (Monday) to 2021-01-10 (Sunday)

Tested with Version: 7.0.0.2 (x64)
Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: de-DE (en_US); UI: en-US
Calc: CL

and Version: 7.2.0.0.alpha0+ (x64)
Build ID: 90668f3473f4e52cec823ad39c6fcb44ba7c089b
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: default; VCL: win
Locale: de-DE (en_US); UI: en-US
Calc: CL

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