BTW there will always be the chance of a small difference in the result of  
YEARFRAC(), because of leap years in case of Mode 1 (exact).
The number of days in a year on which the result is based is the year of the 
first date.
The result is the number of days between the two dates divided by the number of 
days in a year. 
So, even the number of days between two dates is identical, depending on 
whether the first date is a leap year, the result will differ a little bit.

This cannot be avoided, as a year has no fixed length with Mode 1
(exact).

This unavoidable difference is not what causes this bug, this bug can be
fixed :-)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/127505

Title:
  [Upstream] [hardy] YEARFRAC function returns incorrect results for
  some dates

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/127505/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to