Ubuntu
openoffice.org package

  1. Bug #127505
  2. Comment #0

Comment 0 for bug 127505

Revision history for this message
jimgknga (jimgknga) wrote : YEARFRAC function returns incorrect results for some dates

Binary package hint: openoffice.org

=YEARFRAC("3.1.1958";"1.1.1996";1) returns the identical result as =YEARFRAC("3.1.1958";"12.31.1995";1) when, in fact, the two "End dates" are one day apart.

This fails whenever the "End date" is in a leap year (New Year's Eve/Day is convenient) and the "Start date" is not in a leap year but is later than 28-Feb of its year. For example, "Start dates" between "1.1.1958" and "2.28.1958" in the above examples work correctly.

The Microsoft Office Excel equivalent works correctly without this bug.

I found this on Mac OS X 10.4.10 using NeoOffice 2.1 Patch 7; but, re-created it on Windows XP SP 2 using openoffice.org 2.2.1. It also fails on the Linux version I'm running Ubuntu "Feisty Fawn" with openoffice.org 2.2.0.