Has anyone esel run into this problem?
I have a PHP program that calls another 'reader.php' script to read the data in an Excel spreadsheet, and write it to an iSeries database file.
This process was working fine before an upgrade to the user's PC where the spreadsheet is produced, from Windows XP to Windows 7. The version of Excel is still the same (2003).
Now, when the PHP program reads the spreadsheet, any columns that have a value produced by a formula show an incorrect value - the leftmost significant digit has been dropped and several digits of accuarcy are tacked on to the right of the number. ie $576.23 becomes $76.234985.
The cell format in the Excel sheets are exactly the ssame when I compare one that worked to one that does not work.
Any clues anyone can provide would be greatly appreciated!