in my business environment using Excel, there was an application in which the functionality of
MINIF(Range; Criteria; MinRange)
MAXIF(Range; Criteria; MaxRange)
function would have been right on target. Since they are lacking the set of functions that is implemented in Excel, I had to make the experience with the so-called "matrix functions", which was a really, really strange experience!
In order to prevent less involved users from that strange experience, but providing them with that additional and _very_ useful functionality, it would be most comfortable, to add the MINIF and MAXIF functionality to the set of standard functions being available in any cells' formula.
If I got the source code correctly, then the generic design of the ScIterFuncIf might limit the algorithmic part of the code extension to the method
double ScInterpreter::IterateParametersIf( ScIterFuncIf eFunc )
With all the other constants that are required to embed such new functions in a proper way, I do not feel to make any guess on the volume of the necessary changes - still hoping these to be limited, too.
It would really be nice to go that step forward (in front of Excel!) in the open source spreadsheet software, hence it'd be great if you let me know what you are thinking on that potential improvement!
P.S.: I hope that import/export requirements from/to Excel are not a limiting factor for adding such new functions - because then, LibreOffice would always just have to be designated to be (at least) one step behind Excel.
Hi Eike -
Curious if you have a moment to read this and give your input. One of our oldest non triaged calc bugs and just requires a bit of technical expertise. Thanks!
Markus (expert) has said this is a valid enhancement request.
Note: Enhancements are handled by volunteers so we give no ETA as to when (or even if) the enhancement will ever be implemented. It will require a developer with skills taking an interest - given the thousands of requests and bug reports, it may or may not ever happen. Thanks!
These functions have been added in May 2016 as MINIFS and MAXIFS as part of bug #97831.