Problem description: The category in which these functions are located is not consistent with other COUNT functions. Steps to reproduce: 1. Open an instance of Calc and open the Function Wizard. 2. Select the Mathematical category. Current behavior: The 3 named functions are located in this category. Expected behavior: That they would be located with the functions COUNT and COUNTA in the Statistical category and be consistent with Excel. It is noted that all these functions appear in the Information section here; http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#COUNT Operating System: Windows XP Version: 4.1.1.2 release
confirmed in 4.1.1 under Win7 64bit.
Joel, while at bug 69536 please check this one as well.
Patch submitted - it's a separate patch than first one but both are on git ready to be confirmed
Joel Madero committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d269c92a74516081f277d427ab44dbe4ece00598 fdo#69685 - move count functions The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.