[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED

--- Comment #20 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
(In reply to Winfried Donkers from comment #19)
> (In reply to dahrion from comment #17)
> > I had to implement the yearfrac function and can confirm that the error is
> > in the specification.
> > Specifically in ODFv1.2 part 2, §4.11.7.7 line 8
> > it shoul be not(A)
> > also in line 9 the between is inclusive
> 
> There seems to be another aberration in  ODFv1.2 part 2, §4.11.7.7.
> I'm checking this now.

That was a false alarm. It looked as if not all cases when line 7 does not
apply (i.e. F is false) were covered, but they are.

I can confirm that line 8 is incorrect and should be
   8.Otherwise, if (not A) and is-leap-year(year(date1)) then return 366 .

I will try to have a proposal for change of ODFF part 2 §4.11.7.7 submitted.
And then I will change the source code for YEAFRAC to reflect the proposal.

-- 
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/20181114/02d3ad57/attachment.html>