[Upstream] [hardy] YEARFRAC function returns incorrect results for some dates
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Wishlist
|
|||
OpenOffice |
In Progress
|
Unknown
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Reinaldo Enrique Ruiz Duarte | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
Binary package hint: openoffice.org
1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
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/
1:
500 http://
1:
500 http://
3) What is expected to happen is when one types in a cell either:
=YEARFRAC(
=YEARFRAC(
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://
100 /var/lib/
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.
Changed in openoffice.org: | |
importance: | Undecided → Low |
status: | New → Confirmed |
Changed in openoffice: | |
status: | Unknown → Confirmed |
Changed in openoffice: | |
status: | Confirmed → In Progress |
Changed in openoffice.org: | |
status: | Confirmed → Triaged |
tags: | added: hardy |
description: | updated |
tags: | added: lo33 |
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Medium |
status: | New → Triaged |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
importance: | Medium → Wishlist |
Changed in openoffice.org (Ubuntu): | |
status: | Triaged → Won't Fix |
Changed in df-libreoffice: | |
status: | Confirmed → Incomplete |
Changed in df-libreoffice: | |
status: | Incomplete → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Fix Released |
Changed in libreoffice (Ubuntu): | |
assignee: | nobody → Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
assignee: | Reinaldo Enrique Ruiz Duarte (reiruizduarte) → nobody |
Changed in openoffice.org (Ubuntu): | |
assignee: | nobody → Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
assignee: | Reinaldo Enrique Ruiz Duarte (reiruizduarte) → nobody |
Changed in libreoffice (Ubuntu): | |
assignee: | nobody → Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
Confirmed on upstream's openoffice.org 2.4.0~rc2