Bug 21334 - Problem during saving excel file with macros
Summary: Problem during saving excel file with macros
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC All
: P3 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2003-07-04 05:02 UTC by Renu
Modified: 2008-05-17 02:33 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Renu 2003-07-04 05:02:17 UTC
This bug is similar to 19054 and not bug 18155  but i was not able to get any 
answers to that bug. I'm able to read and write excel file without any 
exceptions, but when i try to open the modified excel file it gives me 
error "File error: data may have been lost" and sometime the error is "unable 
to read file". I'm not able to open the modified excel file. Excel contains 5 
worksheets which are referencing to one another and macros. What could be the 

Thanx and Regards,
Comment 1 Danny Mui 2003-07-06 04:53:26 UTC
problem seems when you try to set a value on a cell that contains the
sharedformula.  what is your purpose in doing so? (didnt get a response from the
other user).  I think the best solution would be to undo the shared formula
optimization like we do for the others.
Comment 2 Christian Bourque 2003-07-11 23:29:29 UTC
I have the same problem ("File error: data may have been lost") with a file 
that contains macros and this formula:


If I remove the formula everything works fine! But I don't read/write to this 
cell using POI...

Hope this helps !

Comment 3 Andy Oliver 2003-07-24 17:04:40 UTC
Thats a big formula...  Formula support in 2.0 won't be complete.  I think 3.0
is a better target for this one.
Comment 4 Yegor Kozlov 2008-05-17 02:33:56 UTC
Works with poi-3.1-beta2