DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=27230>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=27230 COUNTIF Formula shows up as #VALUE! Summary: COUNTIF Formula shows up as #VALUE! Product: POI Version: 1.0.2 Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
