|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>|
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".
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 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