poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 37622] New: - Write garbage output when a formula contains Euro symbol.
Date Thu, 24 Nov 2005 08:35:05 GMT
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=37622>.
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=37622

           Summary: Write garbage output when a formula contains Euro
                    symbol.
           Product: POI
           Version: 2.0FINAL
          Platform: Other
        OS/Version: Windows 2000
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: rndbox@yahoo.com


poi-2.0-final-20051122.jar couldn't write Excel output properly when a formula
contains a Euro symbol, e.g, =TEXT('Value is '!H7,"€###,##0")

The output for "€###,##0" will become some garbage, but same length.

If I take out the Euro symbol then everything works fine.

I'm following the Busy Developers' Guide to HSSF:
// Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook.xls");
    wb.write(fileOut);
    fileOut.close();

Note: I have no choice but to use poi 2.0 because all subsequent versions will
cause errors on my workbook (quite complicated), "Unable to read file." and
eventually "Damage to the file was so extensive that repairs were not possible.
 Excel attemted to recover your formulas and values, but some data may have been
lost or corrupted."  -- perhaps I should file another bug report for this later.

If there's no plan to back patch to version 2.0, if anyone know please tell me
where to fix it so that I can do it myself.

Thank you very much.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message