Bug 37260 - #VALUE! shown in the cell where COUNTIF formula used
Summary: #VALUE! shown in the cell where COUNTIF formula used
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.5-FINAL
Hardware: Other Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-10-27 05:22 UTC by Utpal Shahane
Modified: 2008-05-05 13:59 UTC (History)
0 users


Attachments
This class creates the .xls file with formula COUNTIF. (3.21 KB, text/plain)
2005-10-27 05:27 UTC, Utpal Shahane 		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 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)