You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2004/04/15 23:51:42 UTC

DO NOT REPLY [Bug 28420] New: - countif shows as #VALUE!

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=28420>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=28420

countif shows as #VALUE!

           Summary: countif shows as #VALUE!
           Product: POI
           Version: 2.0FINAL
          Platform: PC
        OS/Version: Solaris
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: POI Overall
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: ccheshire@bigredwire.com


On the "summary" sheet cells C6:C9 and E6:E9 have COUNTIF formulas referring to 
other pages in the spreadsheet, but do not calculate in excel until you double 
click the formula, then hit enter.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org