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 problem. Thanx and Regards, Renu
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.
I have the same problem ("File error: data may have been lost") with a file that contains macros and this formula: {=SUM(IF(FREQUENCY(IF(LEN(V4:V220)>0,MATCH(V4:V220,V4:V220,0),""),IF(LEN (V4:V220)>0,MATCH(V4:V220,V4:V220,0),""))>0,1))} If I remove the formula everything works fine! But I don't read/write to this cell using POI... Hope this helps ! Christian
Thats a big formula... Formula support in 2.0 won't be complete. I think 3.0 is a better target for this one.
Works with poi-3.1-beta2 Yegor