Bug 41615

Summary: COUNTIF Function returns #VALUE in the excel file
Product: POI Reporter: Ranga <ranga.duriseti>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: blocker CC: ranga.duriseti, sandeep.haridas
Priority: P1    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   

Description Ranga 2007-02-14 13:25:56 UTC 
COUNTIF formulas do not calculate in excel until you double click the formula 
and hit enter
Comment 1 Nick Burch 2007-08-08 03:17:58 UTC 
You need to explicitly evaluate the formula in POI after changing it, or the
values, otherwise you need to load it in excel and visit the cell to trigger a
re-calculation.

See http://poi.apache.org/hssf/eval.html
Comment 2 Sandeep Haridas 2007-08-09 06:10:02 UTC 
The CountIf function has not yet been implemented in the eval section. This bug 
needs to stay open till an implementation is provided.
Comment 3 Josh Micich 2008-03-14 00:13:30 UTC 
COUNTIF() implementation was added in bug 44345.