ODFF1.2 interpretation of function WEEKNUM
W.Donkers at dci-electronics.nl
Mon Sep 25 07:15:46 UTC 2017
> This reads to me exactly like the ODF spec, so it seems that Excel is not
> abiding by the Excel spec if it returns 29-dec as week 53 ...
> To quote the Excel spec, "System 1 The week containing January 1 is
> the first week of the year, and is numbered week 1." That says to me - as
> a native English speaker, that it is a complete week INCLUDING ANY DAYS
> BEFORE JAN 1.
> So yes. It looks like Excel does not do what it says it does. Quelle
I have studied quite some sources now and have come to the conclusion that there are 2 views:
-a generally shared view that is the same as ODFF1.2. This includes MariaDB SQL.
-a Microsoft view that partial weeks are used. This conflicts a.o. with the Islamitic week numbering system.
I have closed the bug report as NOTOURBUG.
More information about the LibreOffice