Hi
We are involved in the development of an application, having an excel export feature in it. The excel export functionality uses the Apache POI - HSSF. Background: The export has been working well with Microsoft Office 2000. Since the launch of Microsoft Office 2003, the following warning message started appearing. "Errors were detected in 'file.xls' but Microsoft Office Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent. Repairs done: Removed one or more invalid names" The exported excel file was fine after the warning message was discarded. However, comparing the two excel files in 'Text mode' revealed that the file after export from the application and the file after repair by MS Excel, were quite different. Problem: Microsoft recently launched the new patch for Excel - KB943985, after installation of which, the excel export doesn't work and the following message is displayed. "Errors were detected in 'file.xls' but Microsoft Office was able to open the file by making the repairs listed below. Save the file to make these repairs permanent. Repairs done: Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted." The excel file is then displayed with raw data and no formatting. Possible reason: The problem occurs either because Microsoft has because there has been some format changes in the new patch or because the security check has been made more stringent with the new patch that the repairs to such extend were prevented. Querying in the Microsoft forums has revealed that such issues are present for other users also. However, details/solutions regarding the same are not available. I've tried updating the version of Apache POI used to 'poi-3.0.2-FINAL'. However, the issue still remains. We would be really grateful to have some assistance regarding the same. Thanks in advance Best Regards Namith C Cognizant Technology Solutions Phone: +91 973 368 9700 (435336) This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful.
