Bug 41615 - COUNTIF Function returns #VALUE in the excel file
Summary: COUNTIF Function returns #VALUE in the excel file
Status: RESOLVED FIXED
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-14 13:25 UTC by Ranga
Modified: 2008-03-14 00:13 UTC (History)
2 users (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

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
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.