** Description changed: 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. + 1) lsb_release -rd + Description: Ubuntu 11.04 + Release: 11.04 - 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. + 2) apt-cache policy libreoffice-calc + libreoffice-calc: + Installed: 1:3.3.3-1ubuntu2 + Candidate: 1:3.3.3-1ubuntu2 + Version table: + *** 1:3.3.3-1ubuntu2 0 + 100 /var/lib/dpkg/status + 1:3.3.2-1ubuntu5 0 + 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages + 1:3.3.2-1ubuntu4 0 + 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages - The Microsoft Office Excel equivalent works correctly without this bug. + 3) What is expected to happen is when one types in a cell either: - 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. + =YEARFRAC(DATE(1958,3,1),DATE(1996,1,1),1) + =YEARFRAC(DATE(1958,3,1),DATE(1995,12,31),1) + + one gets two different results. + + 4) What happens instead is they are identical: + + 37.8356164384 + 37.8356164384 + + WORKAROUND: Use Gnumeric as the results are: + + 37.8364338364338 + 37.8357230348008 + + apt-cache policy gnumeric + gnumeric: + Installed: 1.10.13-1ubuntu1 + Candidate: 1.10.13-1ubuntu1 + Version table: + *** 1.10.13-1ubuntu1 0 + 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages + 100 /var/lib/dpkg/status + + Original Reporter Comments: This occurs 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.
** Tags added: lo33 ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Medium ** Changed in: libreoffice (Ubuntu) Status: New => Triaged -- 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