After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 630784 - YEARFRAC issues
YEARFRAC issues
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on: 631242
Blocks:
 
 
Reported: 2010-09-28 03:35 UTC by Andreas J. Guelzow
Modified: 2010-10-03 18:14 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2010-09-28 03:35:27 UTC 
(1)  =yearfrac(date(2010,2,28),date(2010,2,28),0) != 0 
      while we get 0 for all other bases.

(2)  =yearfrac(date(2010,2,28),date(2011,2,28),0) != 1

(3)  =yearfrac(date(2000,2,29),date(2008,2,28),0) != 8

This may be by design but it looks very suspicious.
Comment 1 Morten Welinder 2010-09-28 15:25:15 UTC 
Excel produces: 0, 1, 7.994444

So 1 and 2 are bugs, while 3 is not.
Comment 2 Andreas J. Guelzow 2010-09-28 15:51:30 UTC 
Sorry I mistyped #3. It should have been:
=yearfrac(date(2000,2,29),date(2008,2,29),0) != 8
Comment 3 Morten Welinder 2010-09-28 15:58:25 UTC 
In that case, Excel produces 8.
Comment 4 Andreas J. Guelzow 2010-10-03 18:14:44 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.

Note that this fix is in libgoffice.