Issue 102957 - ODFF: FLOOR and CEILING should work with a single argument.
Summary: ODFF: FLOOR and CEILING should work with a single argument.
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-06-19 18:32 UTC by aguelzow
Modified: 2017-05-20 11:11 UTC (History)
2 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---

make the second parameter optional (523 bytes, text/plain)
2009-08-10 22:59 UTC, Regina Henschel
no flags Details
calculate missing optional parameters with they defaults (4.71 KB, text/plain)
2009-08-10 23:00 UTC, Regina Henschel
no flags Details
testcases with missing parameters (14.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-08-10 23:12 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description aguelzow 2009-06-19 18:32:53 UTC
This issue refers to version OOO310.m11 (which cannot be selected from the

According to the OpenFormula draft CEILING and FLOOR only require a single
argument (the second and third argument are optional). OOo yields an error if
only a single argument is given: FLOOR(-2.5)  CEILING (-2.5).
Comment 1 Regina Henschel 2009-06-19 21:10:27 UTC
aguelzow is right, code has to be adapted.
Comment 2 Regina Henschel 2009-08-10 22:57:08 UTC
The patch contains a solution for the spec version
 CEILING( Number N [ ; [ Number significance ] [ ; Number mode ] ] )
where missing optional parameters are calculated with there defaults and a
missing empty first parameter results in an error.

The patch works inside OOo3.2. It is not clear how to import/export Excel
formats and save to ODF1.1 is unclear too.
Comment 3 Regina Henschel 2009-08-10 22:59:13 UTC
Created attachment 64045 [details]
make the second parameter optional
Comment 4 Regina Henschel 2009-08-10 23:00:39 UTC
Created attachment 64046 [details]
calculate missing optional parameters with they defaults
Comment 5 Regina Henschel 2009-08-10 23:12:45 UTC
Created attachment 64048 [details]
testcases with missing parameters
Comment 6 ooo 2011-01-20 12:39:36 UTC
Sorry, this issue and the patch went unnoticed.

Note to self: the missing rewrite for ODF1.0/1.1 and Excel need to be done.
Comment 7 Rob Weir 2013-03-11 15:05:39 UTC
I'm adding this comment to all open issues with Issue Type == PATCH.  We have 220 such issues, many of them quite old.  I apologize for that.  

We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0.

If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know.

On the other hand, if the patch is no longer relevant, please let us know that as well.

If you have any general questions or want to discuss this further, please send a note to our dev mailing list:


Comment 8 Marcus 2017-05-20 11:11:47 UTC
Reset assigne to the default "".