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=31979>. 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=31979 poi library does not support form objects properly. Summary: poi library does not support form objects properly. Product: POI Version: 2.5 Platform: Other OS/Version: Other Status: NEW Severity: Critical Priority: Other Component: POI Overall AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I read a excel file having one form object and rewrite that again using workbook.write() method.The output file which gets generated looks ok but when you try to save that file you get a excel message that 'document not saved' and then when you try to close the file , you get the visual basic message 'file not found' The strange thing is that output file works fine if you change the name of form to something else.The file which does not work has form named 'frmRROptions' and if you change this form name to something else say 'mytestform' and then execute the attached code , the generated output file behaves ok i.e; you don't get any excel or vb message and file saves. It looks like poi library cannot read or write the form objects properly.. I am attaching the input file required to reproduce this problem and the output file generated.. Here is the code i used. ********* FileInputStream fileInputStream = new FileInputStream(new File ("C://docs/UW_Latest.xls")); HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream,true); FileOutputStream fos1 = new FileOutputStream(new File ("c://docs//uw_output.xls")); workbook.write(fos1); fos1.close(); I am attaching the input and output file. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
