CEILING/FLOOR

[Eike Rathke <erack@sun.com>]

Hi,

As can be found in the TODOs, CEILING and FLOOR can have these strange
Excel semantics that round the absolute amount if number and
significance are negative (away from zero for CEILING, toward zero for
FLOOR). This is the reason why OOoCalc introduced a third optional
parameter that if given and not zero signals to do the same.

The possibilities we have are:

1) Use the usual mathematical definition with two parameters, have
   a third optional parameter to mimic the Excel behavior.

2) Use the usual mathematical definition with two parameters, ignoring
   Excel. Optionally define another function that behaves like in Excel.

3) Swap #2 and do like Excel, optionally define another function with
   mathematical behavior.

4) Only copy Excel behavior.

Opinions? I'm undecided between #1 and #2.

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.