Bug 28420 - countif shows as #VALUE!
Summary: countif shows as #VALUE!
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: 2.0-FINAL
Hardware: PC Solaris
: P3 normal with 2 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks: 34973
  Show dependency tree
 
Reported: 2004-04-15 21:51 UTC by Chris Cheshire
Modified: 2008-05-05 13:54 UTC (History)
0 users


Attachments
zip file containing spreadhseet with countif error example (12.13 KB, application/octet-stream)
2004-04-15 21:55 UTC, Chris Cheshire 		Details
View All 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 Chris Cheshire 2004-04-15 21:51:41 UTC 
On the "summary" sheet cells C6:C9 and E6:E9 have COUNTIF formulas referring to 
other pages in the spreadsheet, but do not calculate in excel until you double 
click the formula, then hit enter.
Comment 1 Chris Cheshire 2004-04-15 21:55:25 UTC 
Created attachment 11252 [details]
zip file containing spreadhseet with countif error example
Comment 2 Josh Micich 2008-05-05 13:54:39 UTC 
Retested OK in 3.1-beta1

This was probably fixed due to bug 44675 (var-args param count issues)