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=10943>. 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=10943 Problem when modifying a workbook with a chart included Summary: Problem when modifying a workbook with a chart included Product: POI Version: 1.5.1 Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] I would like to modify a workbook including a sheet with an chart on it. Trying to do this I always running into trouble. Modifying a workbook without a chart in it works without problems. Sometimes the error occurs when I would like to open the Workbook (file workbook.xls) java.lang.NullPointerException at org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet (HSSFSheet.java:171) at org.apache.poi.hssf.usermodel.HSSFSheet.<init>(HSSFSheet.java:134) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:154) at net.gedas.ecu.servlet.util.FehlerAuswertung1Helper.main (FehlerAuswertung1Helper.java:131) Sometimes it occurs when I would like to write the workbook back to the file FehlerAuswertung1.xls: java.lang.ArrayIndexOutOfBoundsException at org.apache.poi.util.LittleEndian.putNumber(LittleEndian.java:550) at org.apache.poi.util.LittleEndian.putShort(LittleEndian.java:242) at org.apache.poi.hssf.record.SelectionRecord.serialize (SelectionRecord.java:261) at org.apache.poi.hssf.model.Sheet.serialize(Sheet.java:584) at org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes (HSSFWorkbook.java:513) at org.apache.poi.hssf.usermodel.HSSFWorkbook.write (HSSFWorkbook.java:465) at net.gedas.ecu.servlet.util.FehlerAuswertung1Helper.main (FehlerAuswertung1Helper.java:163) I have run the file with the charts against Biffviewer and there are unknown records in it. Whatever this means :-( On the POI-homepage I have found the following description: "You can not currently create charts. This is planned for the 2.0 release. You can however create a chart in Excel, modify the chart data values using HSSF and write a new spreadsheet out. This is possible because POI attempts to keep existing records intact as far as possible." In my opinion this is exactly what I want to do! Why does it not work? Kind regards, Arne Clau� -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
