DO NOT REPLY [Bug 31979] New: - poi library does not support form objects properly.

[bu...@apache.org]

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: poi-dev@jakarta.apache.org
        ReportedBy: ash_sha_21@yahoo.com


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: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org