ODFF1.2 interpretation of function WEEKNUM

Winfried Donkers W.Donkers at dci-electronics.nl
Mon Sep 25 07:15:46 UTC 2017

Hi Wol,

> 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
> So yes. It looks like Excel does not do what it says it does. Quelle
> Surprise.

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 mailing list