FLOOR and FLOOR.PRECISE
Submitted by an unknown user
Link to original bug (#702058)
Description
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).
Version: git master