Calc provides five CEILING functions (CEILING, CEILING.MATH, CEILING.PRECISE, CEILING.XCL, and ISO.CEILING) and four FLOOR functions (FLOOR, FLOOR.MATH, FLOOR.PRECISE, and FLOOR.XCL). The current Help descriptions do not properly specify the functional nuances of each variant and it is hard to understand the differences between them from those descriptions. I have drafted replacement help descriptions for each of these nine functions, and these are attached to this bug in two Writer files. These were discussed with Olivier Hallot in advance of raising this bug.
Created attachment 159393 [details] Revised CEILING function descriptions
Created attachment 159394 [details] Revised FLOOR function descriptions
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/2d238deabf589c10ab89b495d3f9e2c57a8efda0 tdf#131960 Clarification of CEILING function
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/ef21ad9a4c0d9fb787392c5a6d24ebe9bb77309e tdf#131960 Clarification of FLOOR functions
Steve Fanning committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/f8cd9798934f2cb336b09990c6d2f84a6cadcc36 tdf#131960 Clarification of FLOOR/CEILING functions
All changes checked in LibreOfficeDev 7.0. Updated status to Resolved / Fixed.