Log in

16 March 2010 @ 01:08 am
ceiling and floor with negative numbers?  
The documentation for Calc clearly says that the ceiling and floor functions are compatible with negative numbers, but every time I try [for example, CEILING(-3.1, 1)], I get a 502 error, "Invalid argument". What's going on here?

I'm using OpenOffice on Debian.
6ferrets6ferrets on March 16th, 2010 08:41 am (UTC)
It seems that the number to be rounded must either be zero or have the same sign as the "significance" in order to avoid the 502 error. This is not explained in the documentation. :-(
aeristilheartlyaeristilheartly on October 12th, 2016 02:32 am (UTC)