You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2020/04/21 11:14:18 UTC

[Bug 64369] New: COUNTIF and <> with wildcard didn't work

https://bz.apache.org/bugzilla/show_bug.cgi?id=64369

            Bug ID: 64369
           Summary: COUNTIF and <> with wildcard didn't work
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: arittner@posteo.de
  Target Milestone: ---

Created attachment 37187
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37187&action=edit
Test to show an Excel sheet with some COUNTIF calculations and the bug

Hello!

The formula COUNTIF(range, "<>*") didn't work as expected. The formula returns
all time 0. 

Other string matchings are working as expected.

This was observed in Apache POI 4.01 and is still not working in 4.1.2.

The attached test class creates a workbook and opens it with Excel (if it's
installed). Please check column D (this is the calculated result from Excel)
and column I. In column I is the calculated value from Apache POI (all zero). 

If you call "Refresh All" to refresh the conditional formatting (this is also
not working for this sheet, but maybe a follow-up error) you can see the
difference cells in yellow.


best regards,
Aljoscha.

PS.: COUNTIF(cell:cell, "<>*") is similar to IF(ISNONTEXT(cell),1,0) and is
used by some Excel heros ;-)

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 64369] COUNTIF and <> with wildcard didn't work

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64369

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 64369] COUNTIF and <> with wildcard didn't work

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64369

--- Comment #1 from Aljoscha Rittner <ar...@posteo.de> ---
Created attachment 37188
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37188&action=edit
Shows the created Excel file with the COUNTIF <>* bug

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org