Bug 27230

Summary:	COUNTIF Formula shows up as #VALUE!
Product:	POI	Reporter:	Rob MacGrogan <robertmacgrogan>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal	CC:	pei_na
Priority:	P3
Version:	2.0-FINAL
Target Milestone:	---
Hardware:	All
OS:	All
Bug Depends on:
Bug Blocks:	34973

Description Rob MacGrogan 2004-02-25 16:59:57 UTC

If you attempt to write a forumla using the COUNTIF function, when you open the
generated sheet in Excel 2000 you get a #VALUE!. The generated formula looks
correct and is legal for Excel, but for some reason does not process. If you
double click it will compile, though.

This is exactly the same problem reported for SUMIF in bug number 11827.

Thanks.

Comment 1 Josh Micich 2008-05-05 13:54:11 UTC

Retested OK in 3.1-beta1

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

Comment 2 Josh Micich 2008-05-05 19:46:11 UTC

*** Bug 35177 has been marked as a duplicate of this bug. ***