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/12/03 11:16:08 UTC
DO NOT REPLY [Bug 44010] New: - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
Summary: Can't open the saved XLS (corrupt file) by HSSF
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: UNCONFIRMED
Severity: blocker
Priority: P1
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: longa@deltacad.fr
I work on a xls with Excel XP and POI HSSF.
It contains 3 charts.
I only open the workbook and then save it into a new xls (without any
modifications).
After that, I can t open the new workbook with Excel 2002 (it is the same with
Excel 2003), I have an error message from Excel ...
My code is :
// open the woorkbook
{
POIFSFileSystem fs =
new POIFSFileSystem(new
FileInputStream(workbookFileNameSrc));
hssfworkbook = new HSSFWorkbook(fs);
//hssfworkbook = new HSSFWorkbook(fs,true);
}
// write the new woorkbook without modifications
FileOutputStream fileOut = new
FileOutputStream(workbookFileNameDest);
this.hssfworkbook.write(fileOut);
fileOut.close();
I have try with POI 3.0.1 final and the latest beta
poi-src-3.0.2-beta1-20071204.zip.
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
------- Additional Comments From longa@deltacad.fr 2007-12-03 03:16 -------
Created an attachment (id=21217)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=21217&action=view)
the same workbook with only one chart (the output xls is correct avec writing
with hssf)
I have make a more simple test.
"Bug_44010_OK.xls" with a limited set of data and only one chart
In this case, it works !
"Bug_44010_OK.xls" with a limited set of data and two charts
In this cas, it's not works.
These xls files are simple. enough simple or not ??
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
longa@deltacad.fr changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #21217|the same workbook with only |the same workbook with only
description|one chart (the output xls is|one chart (the output xls is
|correct avec writing with |correct after writing with
|hssf) |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 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
longa@deltacad.fr changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever Confirmed|0 |1
------- Additional Comments From longa@deltacad.fr 2008-02-14 01:23 -------
Same problem for a another user ...
--
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 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
------- Additional Comments From longa@deltacad.fr 2007-12-03 02:18 -------
Created an attachment (id=21214)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=21214&action=view)
The source workbook
--
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 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
------- Additional Comments From longa@deltacad.fr 2007-12-03 02:19 -------
Created an attachment (id=21215)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=21215&action=view)
the output workbook (cannot be opened with MS Excel)
--
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 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
------- Additional Comments From ms@rationellit.se 2008-02-14 00:45 -------
I have the same problem... A template with one chart works nice to read and then
write with poi, but if you add another worksheet with a chart to the template
and then read and write with poi, excel can't open the 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 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
------- Additional Comments From nick@torchbox.com 2007-12-03 02:45 -------
Are you able to produce a very simple file to show this? Something like a file
with only one chart in it, and only a limited set of data. Or, perhaps a file
with two simple charts that works, and then the same file with a third chart
added, which doesn't.
Tracking down what bit of a file excel has taken objection too is very tricky.
If we have two files, one which works, and one which is very similar but
doesn't, that process is made much easier.
--
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 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
------- Additional Comments From longa@deltacad.fr 2007-12-03 03:22 -------
the correct comment is :
"Bug_44010_OK.xls" with a limited set of data and only one chart
In this case, it works !
"Bug_44010_NOTOK.xls" with a limited set of data and two charts
In this cas, it's not works.
:-)
(In reply to comment #4)
> Created an attachment (id=21216)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=21216&action=view) [edit]
> workbook with data and 2 charts. (Not work)
>
> I have make a more simple test.
>
> "Bug_44010_OK.xls" with a limited set of data and only one chart
> In this case, it works !
>
> "Bug_44010_OK.xls" with a limited set of data and two charts
> In this cas, it's not works.
>
> These xls files are simple. enough simple or not ??
>
> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
longa@deltacad.fr changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #21214|0 |1
is obsolete| |
Attachment #21215|0 |1
is obsolete| |
------- Additional Comments From longa@deltacad.fr 2007-12-03 03:14 -------
Created an attachment (id=21216)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=21216&action=view)
workbook with data and 2 charts. (Not work)
I have make a more simple test.
"Bug_44010_OK.xls" with a limited set of data and only one chart
In this case, it works !
"Bug_44010_OK.xls" with a limited set of data and two charts
In this cas, it's not works.
These xls files are simple. enough simple or not ??
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 44010] - Can't open the saved XLS (corrupt file) by HSSF
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=44010>.
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=44010
------- Additional Comments From longa@deltacad.fr 2007-12-03 03:17 -------
Created an attachment (id=21218)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=21218&action=view)
The source file
the java source
--
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