Workbooks containing scatterplots cause all charts to be deleted when workbook is saved
Created originally on Bitbucket by tldmdeploy (Brandon Lau)
#!python
from openpyxl import load_workbook
wb = load_workbook('test.xlsx')
wb.save('output.xlsx')
Open output.xlsx
and you are presented with the following prompt:
Upon reparing the workbook, all charts are removed and the following XML log file is generated:
#!xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>Repair Result to output0.xml</logFileName><summary>Errors were detected in file '/Users/brandon/projects/tldm/output.xlsx'</summary><removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)</removedPart></removedParts></recoveryLog>
Attachments: test.xlsx