Error in Sumifs/countifs functions?

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Error in Sumifs/countifs functions?

Pierre MIEHE
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Error in Sumifs/countifs functions?

Dominik Stadler
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 <[hidden email]> 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Error in Sumifs/countifs functions?

Greg Woolsey
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 <[hidden email]>
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 <[hidden email]>
> 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: [hidden email]
> > For additional commands, e-mail: [hidden email]
> >
> >
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Error in Sumifs/countifs functions?

Pierre MIEHE
In reply to this post by Dominik Stadler
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:[hidden email]]
Envoyé : mercredi 3 mai 2017 20:58
À : POI Users List <[hidden email]>
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 <[hidden email]> 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: [hidden email] For additional
> commands, e-mail: [hidden email]
>
>


---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Loading...