File opens on Excel Mac but corrupt on Excel Windows drawing1.xml related
Created originally on Bitbucket by Cuevobat (David S. Brown)
The file generated by openpyxl (2.3.3 & 2.3.5) creates a file that Mac OS X 10.10.5 that opens correctly on Mac Excel 2011 14.6.6. However opened on various Windows PCs it reports a corrupted file.
The problem is related to Bar Charts not Radar Charts or cells.
Here is the corruption log:
#!xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error111600_01.xml</logFileName><summary>Errors were detected in file 'https://d.bl3301.docs.live.net/4388919585cbaded/Documents/Prog/..edited.... APR2015_original.xlsx'</summary><removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)</removedPart></removedParts></recoveryLog>
The enclosed files have an original unmodified file and a file opened on Mac and then resaved. The original is corrupt on Windows, the saved one opens on Windows.
Code is available if necessary.
Attachments: Test_APR2015_original.xlsxTest_APR2015_saved_by_Excel.xlsxbuild_bar_chart.py