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 702058 - FLOOR and FLOOR.PRECISE
FLOOR and FLOOR.PRECISE
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2013-06-12 03:20 UTC by Andreas J. Guelzow
Modified: 2018-05-22 14:00 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2013-06-12 03:20:17 UTC 
Excel (as of 2010) has two functions: FLOOR and FLOOR.PRECISE with slightly different behaviour. 

Gnumeric dos not have FLOOR.PRECISE, that is obviously a problem on import. A one argument invocation of FLOOR.PRECISE can be imported as a one-argument FLOOR.

Gnumeric's version of FLOOR has the second argument optional, which is a problem on export if the second argument is not given:
FLOOR(x) should be exported as FLOOR.PRECISE(x).
Comment 2 Andreas J. Guelzow 2013-06-12 05:17:20 UTC 
My statement "FLOOR(x) should be exported as FLOOR.PRECISE(x)" is in fact wrong:

In Gnumeric FLOOR (-3.2) is -3 while in Excel 2010 according to the above link FLOOR.PRECISE(-3.2,1) is 3.

FLOOR(x) in Gnumeric seems to be ROUNDDOWN(x,0) in Excel (and Gnumeric).
Comment 3 Morten Welinder 2013-06-13 18:19:25 UTC 
> FLOOR.PRECISE(-3.2,1) is 3.

I don't see that.  Where?
Comment 4 Andreas J. Guelzow 2013-06-13 19:05:59 UTC 
Sorry, typo on my part; this should have been "FLOOR.PRECISE(-3.2,1) is -4". But of course my point still holds: the GNumeric's result for  FLOOR (-3.2) differs from Excel's result for FLOOR.PRECISE(-3.2,1) (or FLOOR.PRECISE(-3.2)).
Comment 5 GNOME Infrastructure Team 2018-05-22 14:00:10 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/224.