Public bug reported:
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.
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
--
YEARFRAC function returns incorrect results for some dates
https://bugs.launchpad.net/bugs/127505
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
