Bug 18155

Summary:	Writting to a workbook with macros, re-open it, got the "File Error: data may have been Lost".
Product:	POI	Reporter:	Jerry Sun <jsun>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	ramil.israfilov
Priority:	P3
Version:	2.0-dev
Target Milestone:	---
Hardware:	PC
OS:	All
Attachments:	the macro-enabled workbook which has the file open error Thanks for investigating the proble. Here is the workbook file before the test. "BeforeTest.xls" Here is the "AfterTest.xls" which matches the "BeforeTest.xls". Original workbook New generated workbook New generated workbook

Description Jerry Sun 2003-03-19 18:45:41 UTC

First, I created a workbook and defined a macro in the workbook. Then I ran a 
program to write to this workbook (POI version 1.11.0, the latest nightly 
build). When I opened the workbook from Excel, I got an error says "File Error: 
data may have been lost". But I still can open the workbook, all the data in 
the workbook are still there. Not sure what data may have been lost.

Comment 1 Danny Mui 2003-03-19 19:07:27 UTC

Can you attach your workbook?  I'm currently investigating a similar problem
when a DIV by Zero occurs.

Comment 2 Jerry Sun 2003-03-19 23:35:35 UTC

Created attachment 5436 [details]
the macro-enabled workbook which has the file open error

Comment 3 Danny Mui 2003-03-20 01:21:41 UTC

Can you also provide the "before" spreadsheet too?

Comment 4 Jerry Sun 2003-03-20 14:39:27 UTC

Created attachment 5447 [details]
Thanks for investigating the proble. Here is the workbook file before the test. "BeforeTest.xls"

Comment 5 Jerry Sun 2003-03-20 14:40:46 UTC

Created attachment 5448 [details]
Here is the "AfterTest.xls" which matches the "BeforeTest.xls".

Comment 6 Danny Mui 2003-03-29 20:02:59 UTC

Committed fix for FormulaRecord NaN values as of 3/29/2003.

Comment 7 Andy Oliver 2003-07-24 16:13:14 UTC

*** Bug 19054 has been marked as a duplicate of this bug. ***

Comment 8 mariya.klimenko 2004-09-20 17:50:51 UTC

When attempt to open file that has been read by poi get File Error: data may 
have been lost."

Comment 9 Danny Mui 2004-09-24 18:40:36 UTC

going to need you to attach your workbook...

Comment 10 Yong Kong 2004-09-24 19:02:46 UTC

Created attachment 12862 [details]
Original workbook

Comment 11 Yong Kong 2004-09-24 19:03:08 UTC

Created attachment 12863 [details]
New generated workbook

Comment 12 Yong Kong 2004-09-24 19:03:16 UTC

Created attachment 12864 [details]
New generated workbook

Comment 13 Yegor Kozlov 2007-01-12 03:30:48 UTC

Fixed.
See the details in Bug 39234.

Regards,
Yegor

*** This bug has been marked as a duplicate of 39234 ***