RE: ODFF1.2 interpretation of function WEEKNUM

2017-09-26 Thread Winfried Donkers
Hi Eike, > > Which bug# btw? > > Never mind, found it, > https://bugs.documentfoundation.org/show_bug.cgi?id=112320 > > > I'll bring this to the attention of the ODF-TC and, depending on the > > outcome, we may have to change implementation, or introduce some > > WEEKNUM_EXCEL function. > I lo

Re: ODFF1.2 interpretation of function WEEKNUM

2017-09-26 Thread Eike Rathke
Hi Winfried, On Monday, 2017-09-25 16:05:29 +0200, Eike Rathke wrote: > > I have closed the bug report as NOTOURBUG. > > Which bug# btw? Never mind, found it, https://bugs.documentfoundation.org/show_bug.cgi?id=112320 > I'll bring this to the attention of the ODF-TC and, depending on the > out

Re: ODFF1.2 interpretation of function WEEKNUM

2017-09-25 Thread Eike Rathke
Hi Winfried, On Monday, 2017-09-25 09:15:46 +0200, Winfried Donkers wrote: > > 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 1The week containing January 1 i

RE: ODFF1.2 interpretation of function WEEKNUM

2017-09-25 Thread Winfried Donkers
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 1The week containing January 1 is > the first week of the year, and is numbered week 1." That says to me -

Re: ODFF1.2 interpretation of function WEEKNUM

2017-09-22 Thread Wols Lists
On 18/09/17 16:20, Winfried Donkers wrote: > Hi Eike, > > > I'm working on tdf112320 and I think that ODFF1.2 may be ambiguous with > respect to WEEKNUM > (http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#WEEKNUM) > > > My interpretation of the Semantics for Mode 1,2,11

Re: ODFF1.2 interpretation of function WEEKNUM

2017-09-22 Thread Wols Lists
On 18/09/17 16:20, Winfried Donkers wrote: > Hi Eike, > Hi Winfried > > I'm working on tdf112320 and I think that ODFF1.2 may be ambiguous with > respect to WEEKNUM > (http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#WEEKNUM) > > > My interpretation of the Semantics for