Problem description: Both functions have been placed in the Mathematical category of the Function Wizard. Steps to reproduce:Open an instance of Calc. 1. Open the function Wizard 2. Select the Mathematical category 3. Locate the two functions Current behavior:Both functions have been located in the Mathematical category listing. Expected behavior:The two functions should be located in the Statistical category with the other averaging functions AVEDEV, AVERAGE and AVERAGEA. Just as they are in MS Excel. Operating System: Windows XP Version: 4.1.1.2 release
I agree with reporter. Average functions should be grouped in the same category. Those function were not available in 3.6.7 and earlier release while uppear under "mathematical" in 4.1.1 and older releases at least up to 4.0.4 (did not have 4.0.0 --> 4.0.3 to test but I suppose they were added in 4.0.0. interestingly they are kisted under "mathematical" in AOO 4.0.0 as well.
This was probably because AVERAGEIF and AVERAGEIFS are more like SUMIF and SUMIFS that are also in the Mathematical group. However, as both Excel and ODF OpenFormula group them under Statistical, why not move them there..
Making this an EasyHack, source code pointers: sc/source/ui/src/scfuncs.src sc/qa/unit/ucalc.cxx
I'll take it
Patch submitted - ready for review
Joel Madero committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4547d8c42e5b0bb456ac02fbea67059a8a1cadd7 fdo#69536 - Moved Averageif(s) 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.
Can this be closed then?
Fixed
Great :)
Migrating Whiteboard tags to Keywords: (EasyHack,DifficultyBeginner,SkillCpp,TopicUI) [NinjaEdit]