Array formula evaluation: bug or missing feature?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Array formula evaluation: bug or missing feature?

gerard.duong@externe.bnpparibas.com
Hello,

I'm facing a problem in array formula evaluations though FormulaEvaluator.evaluate(Cell).
Especially when I try to do it on a formula cell containing SUMIFS function with range criteria.
I did some source code analysis of Baseifs.evaluate(ValueEval[], OperationEvaluationContext), which Sumifs class inherits. After that, I realize that, when there is no error, a NumberEval is always returned.
This seems to prevent any array result support, whereas Excel handles it correctly.

Do you think it is a bug, or an actual limitation ? I think it is the second case, but I need more feedback, in the case I missed something important.
This is a problem in my application, because it needs to evaluate complex formulas (and store their result), such as these SUMIFS wrapped into aggregate functions (like SUMPRODUCT).


Thanks in advance.


Classification : Internal
This message and any attachments (the "message") is
intended solely for the intended addressees and is confidential.
If you receive this message in error,or are not the intended recipient(s),
please delete it and any copies from your systems and immediately notify
the sender. Any unauthorized view, use that does not comply with its purpose,
dissemination or disclosure, either whole or partial, is prohibited. Since the internet
cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS
(and its subsidiaries) shall not be liable for the message if modified, changed or falsified.
Do not print this message unless it is necessary, consider the environment.

----------------------------------------------------------------------------------------------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le "message")
sont etablis a l'intention exclusive de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur ou s'il ne vous est pas destine,
merci de le detruire ainsi que toute copie de votre systeme et d'en avertir
immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de
ce message qui n'est pas conforme a sa destination, toute diffusion ou toute
publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer
l'integrite de ce message electronique susceptible d'alteration, BNP Paribas
(et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese
ou il aurait ete modifie, deforme ou falsifie.
N'imprimez ce message que si necessaire, pensez a l'environnement.