Bug 91206 - [1] - Mathematical function - interpre.hxx - Extend enum ScIterFuncIf by ifMAXIF and ifMINIF similar to SUMIF
Summary: [1] - Mathematical function - interpre.hxx - Extend enum ScIterFuncIf by i...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2015-05-10 15:37 UTC by CLi
Modified: 2018-10-02 11:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description CLi 2015-05-10 15:37:51 UTC
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.
Comment 1 Joel Madero 2015-10-17 18:11:28 UTC
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!
Comment 2 Joel Madero 2015-10-17 20:49:33 UTC
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!
Comment 3 Winfried Donkers (retired) 2018-10-02 11:56:57 UTC
These functions have been added in May 2016 as MINIFS and MAXIFS as part of bug #97831.