Bug 37260

Summary:	#VALUE! shown in the cell where COUNTIF formula used
Product:	POI	Reporter:	Utpal Shahane <sutpal>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	P2
Version:	2.5-FINAL
Target Milestone:	---
Hardware:	Other
OS:	Windows XP
Attachments:	This class creates the .xls file with formula COUNTIF.

Description Utpal Shahane 2005-10-27 05:22:45 UTC

"if I generate a cell
using it and then open the workbook in Excel the displayed cell value is 
#VALUE!. However, if I look at the geneated Excel file, the formula in the 
cell appears to be set correctly, and if select 
cell and hit enter or double click the cell or hit the function button 
followed by OK, the cell then recalculates correctly."

the same problem with SUMIF was solved through the same way as patch11827 
which works fine.

Comment 1 Utpal Shahane 2005-10-27 05:27:06 UTC

Created attachment 16813 [details]
This class creates the .xls file with formula COUNTIF.

This class creates the .xls file with formula COUNTIF.

Comment 2 Josh Micich 2008-05-05 13:59:21 UTC

Retested OK in 3.1-beta1

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