PHP and PHPExcel setup:
OS: OSX Maverick Development (Production Ubuntu 12.04)
PHPExcel version: 1.7.9, 2013-06-02
We use PHPExcel to generate reports with graphs. Most of the graphs are line charts. These work well on Excel in Win and Mac.
But after upgrading to the latest Excel (2013) the graph reports don't work. Excel shows an error saying:
'We found a problem with some content in [name of the file].xlsx. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes.'
When the user clicks on Yes, next dialog says "Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)"
I tried to upload the generated file into the online Office provided by MS. It says it cannot open because the file is corrupted. But it opens fine on my Excel 2011.
Then I proceeded to open the file in Excel 2011 and click save without changing anything. Then tried to open it in the online Office provided by MS. It opens without issues.
Is there something I can do to fix it?
Is there a way to know what is the difference between the two files before and after I clicked Save in the Excel 2011?
If I extract the Excel files and find the diff between the file: [Content_Types].xml here is what I can find:
If you need diff from another file to find the problem, please let me know.