https://bugs.documentfoundation.org/show_bug.cgi?id=91206
Bug ID: 91206
Summary: [1] - Mathematical function - interpre.hxx - Extend
enum ScIterFuncIf by ifMAXIF and ifMINIF similar
to SUMIF
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
