[odf-discuss] Formula for Disaster

[Daniel Carrera]

Andreas J. Guelzow wrote:
> On Tue, 2007-10-07 at 22:03 +0200, Daniel Carrera wrote:
>> If there is no 'n' value such that CEILING(x ; n) = CEIL(x) for all x I 
>> would consider that a problem. And this is the case in Ecma/MSXML.
> 
> I believe this is also the case in OpenFormula as proposed and OOo as
> implemented. [I believe CEIL(x) = CEILING(x ; sign(x))]

Hm. You're right. But on the other hand, OpenFormula says that if you 
omit the second parameter it is assumed to be sign(x) so you get the 
right behaviour:

CEILING(x) = CEIL(x) = CEILING(x ; sign(x) )

Cheers,
Daniel.