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