RE: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2

2012-05-16 Thread Winfried Donkers
Hi Regina, Van: Regina Henschel [rb.hensc...@t-online.de] Verzonden: dinsdag 15 mei 2012 19:55 The page http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions lists some missing functions in the lower part. And perhaps you add yourself to DATEDIF with comment

RE: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2

2012-05-15 Thread Winfried Donkers
Hi Eike, This took a little longer than I expected as I had to figure out what Excel actually does in DATEDIF. Please see https://bugs.freedesktop.org/show_bug.cgi?id=44456 for changes I did and test case document. For the final algorithm of the function itself best take a look at the

Re: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2

2012-05-15 Thread Eike Rathke
Hi Winfried, On Tuesday, 2012-05-15 08:09:37 +0200, Winfried Donkers wrote: You did a lot of work! I expected some or a lot of comments on my interpretations of ODF1.2 as i don't have Excel to compare with, but you did all the work yourself! I'm a volunteer, I don't mind cleaning up (my

RE: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2

2012-05-15 Thread Winfried Donkers
Hi Eike, Heh, sorry for having taken away the work from you :-) I'll keep that in mind for next time. :) I thought I'd get that algorithm solved because I quite know the date calculation area and the quirks that may be lurking there. Your quite right, of course. Usually for spreadsheet

Re: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2

2012-05-15 Thread Regina Henschel
Hi Winfried, Winfried Donkers schrieb: Hi Eike, Great! I'm looking forward. Do you have already an idea what you'll pick next? I did do a prelimary search of formula-related bugs, but didn't have time yet to look more closely at them. I prefer the formula coding/behaviour itself more than

Re: [PUSHED][PATCH] fdo#44456 added calc function DATEDIF as in ODF 1.2

2012-05-14 Thread Eike Rathke
Hi Winfried, On Wednesday, 2012-05-09 16:49:41 +0200, Winfried Donkers wrote: Attached patch adds function DATEDIF to calc as defined in ODF1.2 (6.10.3) This took a little longer than I expected as I had to figure out what Excel actually does in DATEDIF. Please see