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 2007/08/09 14:31:36 UTC
DO NOT REPLY [Bug 43071] New: - Read/write problems on Excel files containing charts
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=43071>.
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=43071
Summary: Read/write problems on Excel files containing charts
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: zwick@in.tum.de
Overview Description:
When creating a workbook from an Excel file that contains a chart and
immediately writing the workbook to an output stream without performing any
manipulations, the resultung Excel file is damaged. This occurs only if the
chart contained in the input file is a seperate sheet (and not a part of a table
sheet) and followed by another sheet.
Steps to Reproduce:
The problem arises when executing the following lines of code.
File inputFile = new File( "InputFile.xls" );
File directory = new File( "Temp" );
File outputFile = File.createTempFile( "OutputFile.", ".xls", directory );
POIFSFileSystem fileSystem = new POIFSFileSystem(
new FileInputStream( inputFile ) );
HSSFWorkbook workbook = new HSSFWorkbook( fileSystem );
HSSFSheet sheet = workbook.getSheetAt( 0 );
FileOutputStream outputStream = new FileOutputStream( outputFile );
workbook.write( outputStream );
outputStream.close();
Actual Results:
When trying to open the output file in Excel, the following error messages are
displayed.
"Kann Datei nicht lesen." -> Return
"Kann Datei nicht lesen." -> Return
"In Datei 'OutputFile.39744.xls' wurden Fehler festgestellt.
Die folgenden Reparaturen wurden durchgef�hrt:
Die Datei war so stark besch�digt, dass sie nicht repariert werden konnte. Excel
hat versucht, Ihre Formeln und Zahlen wieder herzustellen, aber einige Daten
sind m�glicherweise verloren gegangen."
Expected Results:
The output file schould have the same content as the input file. There should be
no differences between them when opening the files in Excel.
Build Date & Platform:
Build 2007-07-31 on Windows XP Professional, Version 2002, SP 2
Additional Builds and Platforms:
Unknown.
Additional Information:
This bug is similar to 10943.
--
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 43071] - Read/write problems on Excel files containing charts
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=43071>.
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=43071
------- Additional Comments From trancongkhanh@gmail.com 2007-10-11 20:58 -------
Created an attachment (id=20968)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=20968&action=view)
This is the damaged 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 43071] - Read/write problems on Excel files containing charts
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=43071>.
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=43071
------- Additional Comments From trancongkhanh@gmail.com 2007-10-11 20:57 -------
Created an attachment (id=20967)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=20967&action=view)
This is the original 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 43071] - Read/write problems on Excel files containing charts
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=43071>.
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=43071
------- Additional Comments From longa@deltacad.fr 2007-12-03 06:04 -------
Maybe the same bug as 44010 ?
--
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 43071] - Read/write problems on Excel files containing charts
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=43071>.
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=43071
------- Additional Comments From zwick@in.tum.de 2007-08-09 05:38 -------
Created an attachment (id=20623)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=20623&action=view)
Damaged Excel output file generated by POI-HSSF
--
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 43071] - Read/write problems on Excel files containing charts
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=43071>.
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=43071
------- Additional Comments From trancongkhanh@gmail.com 2007-10-11 20:56 -------
I am facing the same problem, althrough my file doesn't contains any chart.
Another case, I created a file and insert some charts, it works file.
So, the problem isn't on the chart.
--
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 43071] - Read/write problems on Excel files containing charts
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=43071>.
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=43071
------- Additional Comments From zwick@in.tum.de 2007-08-09 05:36 -------
Created an attachment (id=20622)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=20622&action=view)
Excel input file containing a chart sheet
--
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