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

Excel-Sheet can not write out, if original one contains a formula

           Summary: Excel-Sheet can not write out, if original one contains
                    a formula
           Product: POI
           Version: 1.5
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


If you open an existing excel and you will add that with some data from your 
java program, it will fail if the excel file contains a formula.

Exception in thread "main" java.lang.NullPointerException
        at org.apache.poi.hssf.record.FormulaRecord.getTotalPtgSize
(FormulaRecord.java, Compiled Code)
        at org.apache.poi.hssf.record.FormulaRecord.serialize
(FormulaRecord.java:335)
        at org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate.serialize
(ValueRecordsAggregate.java, C
ompiled Code)
        at org.apache.poi.hssf.model.Sheet.serialize(Sheet.java, Compiled Code)
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes
(HSSFWorkbook.java, Compiled Code)
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.write
(HSSFWorkbook.java:465)
        at XmlWriteToExcel.closeWriteSheets(XmlWriteToExcel.java:194)
        at XmlWriteToExcel.mapFiles(XmlWriteToExcel.java:223)
        at XmlWriteToExcel.main(XmlWriteToExcel.java:290)

I tried to read out every sheet, row and cell, to populate the values, but 
without success.

Reply via email to