https://bugs.documentfoundation.org/show_bug.cgi?id=139421
Regina Henschel <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #3 from Regina Henschel <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
