Hi,

I'am currently looking at issue 102957 "ODFF: FLOOR and CEILING should work with a single argument." Now OOo allows CEILING(N;Significance;Mode) and CEILING(N;Significance). I have made some changes to allow CEILING(N) too. Thereby I noticed the following problem:

OOo allows CEILING(N;;Mode) where the second parameter is missing. It does this already in version OOo2.4.2 But that is not allowed in spec (chapter 6.16.1). Unfortunately I can not do anything in ScCeil, because in this case nParamCount is already 3 and it seems that the missing parameter is set to 0. Besides the fact, that a missing second parameter is not allowed, the default for the second parameter has to be +1 or -1 depending on the sign of N.

I would expect, that the case CEILING(N;;Mode) raises a "Variable missing" error. But I don't now, where this should happen. Could you please point me to that place?

kind regards
Regina

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to