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 2004/06/16 20:17:08 UTC
DO NOT REPLY [Bug 29619] New: -
Excel file becomes corrupt after sheet deletion
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=29619>.
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=29619
Excel file becomes corrupt after sheet deletion
Summary: Excel file becomes corrupt after sheet deletion
Product: POI
Version: 2.0FINAL
Platform: PC
OS/Version: Windows NT/2K
Status: NEW
Severity: Major
Priority: Other
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: matthieu.ursenbach@atosorigin.com
Environment: W2K-SP4
Excel 2000 9.0.6926 SP-3
POI2.0 Final
Bug report:
1) The following test set works systematically:
First I create with Excel my template file called 'testDeletionIn.xls'
There are 3 sheets in this file 'A', 'Graph' and 'B'. Both 'A' and 'B' sheets
are almost empty but 'Graph' contains a shart.
The template file is used to generate 3 different output files
'testDeletionOut1.xls' in wich sheet 'Graph' is deleted
'testDeletionOut2.xls' in wich sheet 'A' is deleted
'testDeletionOut3.xls' in wich sheet 'B' is deleted
All this generated files are readable with Excel but in 'testDeletionOut2.xls'
the shart values are redirected in sheet 'B'.
It's not a significant bug because it depend the ordre in wich I remove the
sheets
2) The test continues :
A single macro is added into a copy of 'testDeletionIn.xls'
I retry deletion test on this file called 'testDeletionInMacro.xls' to
obtain 'testDeletionOutMacro1.xls', 'testDeletionOutMacro2.xls'
and 'testDeletionOutMacro3.xls'
In this case, I cannot open any of this files with Excel.
The error message looks like :
"EXCEL.exe has generated errors and will be closed by windows.
You need to restart the program.
An error log..."
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org