I have installed the same version of "MS Office 2007" in Windows 7 and Windows XP operating systems.
I have a Excel file generated by a non-microsoft program (a java
program) with me.
HSSF POI jar version is 1.5.1 (name of jar is jakarta-poi-1.5.1-final-20020615.jar
I tried opening the file in windows xp, using Excel 2007.. The file opened and I was able to see all the data.
But when I copied the same excel file to Windows7 OS, and tried to open with the same installation of Office 2007, I get the an alert box with following message.
"Excel found unreadable content in "xyz.xls".Do you want to recover the contents of the workbook.If you trust the source of this workbook, click Yes"..
Once I click yes, the file opens displaying a message as follows.
"Excel recovered your formulas and cell values, but some data may have been lost"...
Some data is lost when I open the same file in Windows 7 OS, Excel 2007...
Any clues about why I am losing the data in Windows 7 but the file opens correctly in WinXP..
Is there any problem with the way I created the workbook..? Please help..