Documentation : http://vm173.documentfoundation.org/text/scalc/01/04060115.xhp#bm_id2983446 Actual: Syntax ERF.PRECISE(LowerLimit; UpperLimit) expected: Syntax ERF.PRECISE(LowerLimit) This syntax is used in function wizzard. See the excel's docs: https://support.office.com/en-US/article/ERF-PRECISE-function-9A349593-705C-4278-9A98-E4122831A8E0 Example in documentation (=ERF.PRECISE(0;1) ) returns error in Calc. Function was added into Calc in bug 73149.
Confirmed. Looks like the lower/upper limit is dynamically, depends on what number is given.
Patch submitted to Gerrit: https://gerrit.libreoffice.org/#/c/28735/
Stanislav Horacek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=fbd93f4c667396b55f7c2df3707590ba56218b39 tdf#101805 correct documentation for ERF.PRECISE function