Bug 41615 - COUNTIF Function returns #VALUE in the excel file
Summary: COUNTIF Function returns #VALUE in the excel file
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC Windows 2000
: P1 blocker with 2 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2007-02-14 13:25 UTC by Ranga
Modified: 2008-03-14 00:13 UTC (History)
2 users (show)


Note You need to log in before you can comment on or make changes to this bug.
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

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.