Ubuntu
openoffice.org package

  1. Bug #127505
  2. Comment #12

Comment 12 for bug 127505

Revision history for this message
In , E-osc (e-osc) wrote :

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 :-)