poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Stadler <dominik.stad...@gmx.at>
Subject Re: Error in Sumifs/countifs functions?
Date Wed, 03 May 2017 18:58:03 GMT
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 <miehe.pierre@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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message