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

Posted to dev@cocoon.apache.org by bu...@apache.org on 2003/08/20 09:42:13 UTC

DO NOT REPLY [Bug 22574] New: - poi HSSFSerializer error with formula cells

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=22574>.
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=22574

poi HSSFSerializer error with formula cells

           Summary: poi HSSFSerializer error with formula cells
           Product: Cocoon 2
           Version: Current CVS 2.1
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: sitemap components
        AssignedTo: dev@cocoon.apache.org
        ReportedBy: nbacon@pinnaclesoftware.com.au


With cocoon-2.1m3 I had a Cell with a date format and content set with 
something like:
<gmr:Cell Col="5" Row="4" ValueType="40">=DATE(2001, 1, 1)</gmr:Cell>
which was correctly displayed in excel as a date.

This doesn't work with cocoon-2.1 because some lines have been commented out in 
version 1.4 of
org\apache\cocoon\components\elementprocessor\impl\poi\hssf\elements\Cell.java
with the comment:
This part is plain wrong: in gnumeric a formula cell is a cell lacking the 
ValueType attribute 
Disabled this code until someone implements it correctly.

>From this clue I've made a patch which seems to do this.