You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Pierre MIEHE <mi...@gmail.com> on 2017/05/03 13:27:40 UTC
Error in Sumifs/countifs functions?
Dear all,
I am currently using the NPOI version of POI for C#, and I have a doubt about the countifs and sumifs function: it seems they give wrong results no?
I looked at the code on http://www.lookatsrc.com/source/org/apache/poi/ss/formula/functions/Countifs.java?a=org.apache.poi:poi
and I have indeed the impression it takes the minimum value of countif for the couples of parameters, instead of applying an "and" to each cell; did I get something wrong?
Thank you in advance for your help and best wishes,
Pierre
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Error in Sumifs/countifs functions?
Posted by Pierre MIEHE <mi...@gmail.com>.
Indeed the code in the link you sent is corrected, so this is just a version problem.
Thank you!
Pierre
-----Message d'origine-----
De : Dominik Stadler [mailto:dominik.stadler@gmx.at]
Envoyé : mercredi 3 mai 2017 20:58
À : POI Users List <us...@poi.apache.org>
Objet : Re: Error in Sumifs/countifs functions?
Hi,
Which version of POI is this? Can you try with the latest release 3.16?
There have been fixes in this area, especially
https://bz.apache.org/bugzilla/show_bug.cgi?id=56822 seems to be related.
Dominik.
On Wed, May 3, 2017 at 3:27 PM, Pierre MIEHE <mi...@gmail.com> wrote:
> Dear all,
>
> I am currently using the NPOI version of POI for C#, and I have a
> doubt about the countifs and sumifs function: it seems they give wrong results no?
> I looked at the code on
> http://www.lookatsrc.com/source/org/apache/poi/ss/
> formula/functions/Countifs.java?a=org.apache.poi:poi
> and I have indeed the impression it takes the minimum value of countif
> for the couples of parameters, instead of applying an "and" to each
> cell; did I get something wrong?
>
> Thank you in advance for your help and best wishes,
>
> Pierre
>
>
>
> ---
> L'absence de virus dans ce courrier électronique a été vérifiée par le
> logiciel antivirus Avast.
> https://www.avast.com/antivirus
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
> commands, e-mail: user-help@poi.apache.org
>
>
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Error in Sumifs/countifs functions?
Posted by Greg Woolsey <gr...@gmail.com>.
NPOI is not an Apache project, and as far as I know, has no ongoing
relationship with this project. You should ask your question in whatever
forum that project provides. I know in the Java Apache POI project those
functions had some updates in the latest 3.16 release, so it doesn't
surprise me that other language implementations may not match the latest
POI functionality.
On Wed, May 3, 2017 at 11:58 AM Dominik Stadler <do...@gmx.at>
wrote:
> Hi,
>
> Which version of POI is this? Can you try with the latest release 3.16?
> There have been fixes in this area, especially
> https://bz.apache.org/bugzilla/show_bug.cgi?id=56822 seems to be related.
>
> Dominik.
>
> On Wed, May 3, 2017 at 3:27 PM, Pierre MIEHE <mi...@gmail.com>
> wrote:
>
> > Dear all,
> >
> > I am currently using the NPOI version of POI for C#, and I have a doubt
> > about the countifs and sumifs function: it seems they give wrong results
> no?
> > I looked at the code on
> http://www.lookatsrc.com/source/org/apache/poi/ss/
> > formula/functions/Countifs.java?a=org.apache.poi:poi
> > and I have indeed the impression it takes the minimum value of countif
> for
> > the couples of parameters, instead of applying an "and" to each cell;
> did I
> > get something wrong?
> >
> > Thank you in advance for your help and best wishes,
> >
> > Pierre
> >
> >
> >
> > ---
> > L'absence de virus dans ce courrier électronique a été vérifiée par le
> > logiciel antivirus Avast.
> > https://www.avast.com/antivirus
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> > For additional commands, e-mail: user-help@poi.apache.org
> >
> >
>
Re: Error in Sumifs/countifs functions?
Posted by Dominik Stadler <do...@gmx.at>.
Hi,
Which version of POI is this? Can you try with the latest release 3.16?
There have been fixes in this area, especially
https://bz.apache.org/bugzilla/show_bug.cgi?id=56822 seems to be related.
Dominik.
On Wed, May 3, 2017 at 3:27 PM, Pierre MIEHE <mi...@gmail.com> wrote:
> Dear all,
>
> I am currently using the NPOI version of POI for C#, and I have a doubt
> about the countifs and sumifs function: it seems they give wrong results no?
> I looked at the code on http://www.lookatsrc.com/source/org/apache/poi/ss/
> formula/functions/Countifs.java?a=org.apache.poi:poi
> and I have indeed the impression it takes the minimum value of countif for
> the couples of parameters, instead of applying an "and" to each cell; did I
> get something wrong?
>
> Thank you in advance for your help and best wishes,
>
> Pierre
>
>
>
> ---
> L'absence de virus dans ce courrier électronique a été vérifiée par le
> logiciel antivirus Avast.
> https://www.avast.com/antivirus
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>