Bug 35177

Summary: Problem generating formulas containing COUNTIF()
Product: POI Reporter: peina <pei_na>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: Other   
OS: other   

Description peina 2005-06-02 07:58:33 UTC 
When using the COUNTIF() formula,it performances like bug11827:

"if I generate a cell
using it and then open the workbook in Excel 97 (or 2000)
the displayed cell value is #VALUE!. However, if I look at the contents of
the cell, the formula appears to be set correctly, and if I double-click
on the cell, or hit the function button followed by OK, the cell then
recalculates correctly."

this problem could be resolved through the same way as patch11827.
Comment 1 Josh Micich 2008-05-05 19:46:11 UTC 

*** This bug has been marked as a duplicate of bug 27230 ***