** 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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
