Created attachment 27395 [details] Problematic Excel I am using the latest version of POI3.7 (even tried the 3.8-beta3), the problem of LeftoverDataException still exists in the attached XLS. I tried to open the XLS by Excel, and resaved once. The problem is fixed. But the problem is, the file is generated by a 3rd party and I don't know what tool generated the file. I can only access the file online. I can't resave a huge amount of files manually one-by-one. Please Help!
I confirmed the problem in trunk. Something to fix in future releases. Yegor
Thanks for your prompt response, Yegor. Looking forward to the next release of POI.
Hi Yegor, Before the bug is fixed in the next version, can I have a quick fix for this? I downloaded the source of 3.8-Beta4 and built a version by myself. I tried to trace for the problem, but I have no idea where's the root cause of the problem. Can you give me some suggestions, so that I can fix it and build a temporary version for our own use immediately? As we are now in a tight development schedule, and can not wait for a very long time. Many thanks! Regards, Jan
Fixed in r1169725, junit added. Yegor
Thanks for your help to fix the problem. I built a version, and its working now. Thanks :)