Dear developers,

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!

Best regards,
Christian

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.