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 323787 - funb.xls: BIN2*() functions not Excel compatible
funb.xls: BIN2*() functions not Excel compatible
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-12-11 13:14 UTC by Nick Lamb
Modified: 2005-12-12 20:27 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Nick Lamb 2005-12-11 13:14:42 UTC 
http://www.ecs.soton.ac.uk/~njl98r/excel/funb.xls

The BIN2DEC, BIN2HEX, BIN2OCT pseudo-binary conversion functions have several
common incompatibilities with Excel, found with the test workbook:

1. For very large input values such as 1E+10 Excel gives #NUM! while Gnumeric
seems to ignore the "top" bits. Excel's behaviour definitely seems preferable here.

2. For negative or impossible values of 'places' Excel gives #NUM! while
Gnumeric seemingly just ignores 'places'. Once again Excel's behaviour seems
preferable.

3. For non-numeric values of 'number', such as strings, or the boolean FALSE,
Excel gives #VALUE! while Gnumeric gives #NUM!. Excel's help is clear about
this, and there seems no particular reason to keep Gnumeric's current behaviour.
Comment 1 Morten Welinder 2005-12-12 03:07:09 UTC 
Partially fixed in cvs.
Comment 2 Morten Welinder 2005-12-12 15:50:59 UTC 
Re 3: Excel _does_ allow strings, but only strings that are composed entirely
of digits.  No spaces, no signs, no dates-as-strings, no decimal point, no
nothing.

And BIN2DEC("") is 0.
Comment 3 Morten Welinder 2005-12-12 20:27:20 UTC 
Fixed in cvs head.  Those functions are *u*g*l*y!