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 623764 - HDATE returns strange results if arguments are missing.
HDATE returns strange results if arguments are missing.
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other Linux
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-07-07 16:18 UTC by Andreas J. Guelzow
Modified: 2010-07-07 17:52 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2010-07-07 16:18:03 UTC 
=hdate(,,)

returns

-1077820295 (null) 0

I would have expected an error message.
Comment 1 Andreas J. Guelzow 2010-07-07 16:24:07 UTC 
hdate_day, hdate_month, hdate_heb result is similarly strange results.

hdate_year(,,) results in 0 which may or may not be sensible, while hdate_julian(,,) results in 1721028 which may have some meaning.

Note that the values of hdate and hdate_day occasionally change on recalculation.
Comment 2 Andreas J. Guelzow 2010-07-07 17:51:46 UTC 
hdate, hdate_day, hdate_month, hdate_he,b hdate_year and hdate_julian have been fixed (making the argument defaulting to the current date)
Comment 3 Andreas J. Guelzow 2010-07-07 17:52:46 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.