| 2007-07-22 07:32:40 |
jimgknga |
bug |
|
|
added bug |
| 2007-11-14 21:29:35 |
Chris Cheney |
openoffice.org: importance |
Undecided |
Low |
|
| 2007-11-14 21:29:35 |
Chris Cheney |
openoffice.org: status |
New |
Confirmed |
|
| 2007-11-14 21:29:46 |
Chris Cheney |
bug |
|
|
assigned to openoffice |
| 2007-11-15 11:37:51 |
Bug Watch Updater |
openoffice: status |
Unknown |
Confirmed |
|
| 2007-12-19 10:22:50 |
Bug Watch Updater |
openoffice: status |
Confirmed |
In Progress |
|
| 2008-03-13 01:08:36 |
Chris Cheney |
title |
YEARFRAC function returns incorrect results for some dates |
[Upstream] [hardy] YEARFRAC function returns incorrect results for some dates |
|
| 2008-06-13 18:49:46 |
Chris Cheney |
openoffice.org: status |
Confirmed |
Triaged |
|
| 2010-05-13 21:55:23 |
Chris Cheney |
tags |
|
hardy |
|
| 2010-12-15 04:32:39 |
Robert Roth |
bug |
|
|
added subscriber Robert Roth |
| 2011-08-15 10:03:58 |
penalvch |
bug task added |
|
libreoffice (Ubuntu) |
|
| 2011-08-15 10:18:17 |
penalvch |
description |
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. |
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/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
3) What is expected to happen is when one types in a cell either:
=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. |
|
| 2011-08-15 10:18:35 |
penalvch |
tags |
hardy |
hardy lo33 |
|
| 2011-08-15 10:19:13 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Medium |
|
| 2011-08-15 10:19:13 |
penalvch |
libreoffice (Ubuntu): status |
New |
Triaged |
|
| 2011-08-15 10:25:27 |
penalvch |
bug watch added |
|
http://bugs.freedesktop.org/show_bug.cgi?id=40100 |
|
| 2011-08-15 10:25:27 |
penalvch |
bug task added |
|
df-libreoffice |
|
| 2011-08-15 11:15:52 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
| 2011-08-15 11:15:52 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Medium |
|
| 2011-08-19 13:32:45 |
Bug Watch Updater |
df-libreoffice: importance |
Medium |
Wishlist |
|
| 2011-09-15 14:18:13 |
Björn Michaelsen |
openoffice.org (Ubuntu): status |
Triaged |
Won't Fix |
|
| 2011-12-24 15:26:34 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Incomplete |
|
| 2012-01-17 23:14:21 |
Bug Watch Updater |
df-libreoffice: status |
Incomplete |
Confirmed |
|
| 2013-04-23 03:16:25 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Fix Released |
|
| 2013-10-09 01:39:03 |
Chris Halse Rogers |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
| 2013-10-09 01:39:06 |
Chris Halse Rogers |
bug |
|
|
added subscriber SRU Verification |
| 2013-10-09 01:39:09 |
Chris Halse Rogers |
tags |
hardy lo33 migrateoootolo |
hardy lo33 migrateoootolo verification-needed |
|
| 2013-10-28 22:06:24 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
Triaged |
Fix Released |
|
| 2013-12-05 12:26:10 |
Björn Michaelsen |
tags |
hardy lo33 migrateoootolo verification-needed |
hardy lo33 migrateoootolo verification-failed |
|
| 2015-04-11 16:39:17 |
Reinaldo Enrique Ruiz Duarte |
libreoffice (Ubuntu): assignee |
|
Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
|
| 2015-04-11 16:39:29 |
Reinaldo Enrique Ruiz Duarte |
libreoffice (Ubuntu): assignee |
Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
|
|
| 2015-04-11 16:40:09 |
Reinaldo Enrique Ruiz Duarte |
openoffice.org (Ubuntu): assignee |
|
Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
|
| 2015-04-11 16:41:12 |
Reinaldo Enrique Ruiz Duarte |
openoffice.org (Ubuntu): assignee |
Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
|
|
| 2015-04-11 16:42:24 |
Reinaldo Enrique Ruiz Duarte |
libreoffice (Ubuntu): assignee |
|
Reinaldo Enrique Ruiz Duarte (reiruizduarte) |
|
