[Libreoffice-bugs] [Bug 100070] UKENR (Norwegian WEEKNUM function) gives wrong week numbers.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Alex H. <alexhfromnorthholland at gmail.com> ---
I didn't try in Norwegian, only in English, but I can confirm the behavior.
However, I think that the behavior is correct and that there is a mistake in
the documentation.

At https://help.libreoffice.org/Calc/WEEKNUM it says:

  System 1: The week containing January 1 is the first week of the
  year, and is numbered week 1.

In other words, if the mode argument is either absent, 1, 2, 11, 12, 13, 14,
15, 16 or 17, for January 1st of _any_ year the return value must be 1.

However, this directly contradicts the example further down on the same page:

  =WEEKNUM(DATE(1995;1;1);2) returns 52. If the week starts on Monday,
  Sunday belongs to the last week of the previous year.

This is wrong, I think. January 1st 1995 was a Sunday, but that doesn't even
matter under system 1, where the outcome should be 1 regardless of which day
the week starts on.

(The Norwegian version of that page,
https://help.libreoffice.org/Calc/WEEKNUM/nb, contains essentially the same
text.)

-- 
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/20171209/30b21603/attachment-0001.html>