Bug 18155 - Writting to a workbook with macros, re-open it, got the "File Error: data may have been Lost".
Summary: Writting to a workbook with macros, re-open it, got the "File Error: data may...
Status: RESOLVED DUPLICATE of bug 39234
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
: 19054 (view as bug list)
Depends on:
Blocks:
 
Reported: 2003-03-19 18:45 UTC by Jerry Sun
Modified: 2007-01-12 03:30 UTC (History)
1 user (show)


Attachments
the macro-enabled workbook which has the file open error (197.00 KB, application/octet-stream)
2003-03-19 23:35 UTC, Jerry Sun 		Details
Thanks for investigating the proble. Here is the workbook file before the test. "BeforeTest.xls" (192.50 KB, application/octet-stream)
2003-03-20 14:39 UTC, Jerry Sun 		Details
Here is the "AfterTest.xls" which matches the "BeforeTest.xls". (197.00 KB, application/octet-stream)
2003-03-20 14:40 UTC, Jerry Sun 		Details
Original workbook (62.00 KB, application/octet-stream)
2004-09-24 19:02 UTC, Yong Kong 		Details
New generated workbook (62.00 KB, application/octet-stream)
2004-09-24 19:03 UTC, Yong Kong 		Details
New generated workbook (62.00 KB, application/octet-stream)
2004-09-24 19:03 UTC, Yong Kong 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***