You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2006/11/24 16:08:18 UTC

DO NOT REPLY [Bug 41038] New: - corrupte output XLS file ( read existing xls then write without modification )

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

           Summary: corrupte output XLS file ( read existing xls then write
                    without modification )
           Product: POI
           Version: 3.0-dev
          Platform: PC
        OS/Version: Windows 2000
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: neuser1@caramail.com


I'am trying to write to an existing XLS file. For the moment i only open 
existing file then write with POI API.

i use this java code:

in = new BufferedReader(new FileReader(infileName));
POIFSFileSystem fs      =     new POIFSFileSystem(new FileInputStream
(outfileName));
SSFWorkbook wb = new HSSFWorkbook(fs,false);
String finalName = outfileName.substring( 0,outfileName.length()-4) 
+ "_out.xls";
FileOutputStream fileOut = new FileOutputStream(finalName);
wb.write(fileOut);
fileOut.close();
in.close();

- This code works well on simple xls file ( 1 cell with hello ) but problems 
appears with my real input xls file. Excell cannot open the output xls file.( 
Excell 2000/Excell viewer 2003 )
- I use the last release and last dev version. same problem.
- while executing, no error, no exception.

I dont known how to attach my XLS input file

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


DO NOT REPLY [Bug 41038] - corrupte output XLS file ( read existing xls then write without modification )

Posted by 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=41038>.
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=41038





------- Additional Comments From avik@apache.org  2007-01-16 02:08 -------
Could you try with the latest SVN and check if you problem still appears? Thanks

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


DO NOT REPLY [Bug 41038] - corrupte output XLS file ( read existing xls then write without modification )

Posted by 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=41038>.
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=41038


yegor@dinom.ru changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
OtherBugsDependingO|                            |42420
              nThis|                            |




-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


DO NOT REPLY [Bug 41038] - corrupte output XLS file ( read existing xls then write without modification )

Posted by 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=41038>.
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=41038





------- Additional Comments From neuser1@caramail.com  2006-11-24 07:12 -------
Created an attachment (id=19169)
 --> (http://issues.apache.org/bugzilla/attachment.cgi?id=19169&action=view)
My input XLS file that occurs problem.

i found how to attach :)
Problems disappear/appear when suppressing cell M192 but if i let this alone by
copying cell M192 on A1, no problem occurs.
.....


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


DO NOT REPLY [Bug 41038] - corrupte output XLS file ( read existing xls then write without modification )

Posted by 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=41038>.
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=41038





------- Additional Comments From yegor@dinom.ru  2007-04-13 23:51 -------
We still have this bug in the latest RC.

At least I located the problem. 
The attached xls contains MulBlankRecords that result in corruption.
We have read-only support for this record type. When reading, each
MulBlankRecord is converted into a
a set of BlankRecord. When writing back out, the BlankRecords are serialized
instead of the original MulBlankRecord. 
This is the issue.

Yegor


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/