Bug 64369 - COUNTIF and <> with wildcard didn't work
Summary: COUNTIF and <> with wildcard didn't work
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-21 11:14 UTC by Aljoscha Rittner
Modified: 2020-05-14 16:19 UTC (History)
0 users



Attachments
Test to show an Excel sheet with some COUNTIF calculations and the bug (6.21 KB, text/plain)
2020-04-21 11:14 UTC, Aljoscha Rittner
Details
Shows the created Excel file with the COUNTIF <>* bug (47.95 KB, image/png)
2020-04-21 11:20 UTC, Aljoscha Rittner
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aljoscha Rittner 2020-04-21 11:14:18 UTC
Created attachment 37187 [details]
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 ;-)
Comment 1 Aljoscha Rittner 2020-04-21 11:20:09 UTC
Created attachment 37188 [details]
Shows the created Excel file with the COUNTIF <>* bug