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.