Workbooks containing scatterplots cause all charts to be deleted when workbook is saved

Issue #882 resolved
Brandon Lau
created an issue
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:

Screen Shot 2017-08-28 at 4.26.20 PM.png

Upon reparing the workbook, all charts are removed and the following XML log file is generated:

<?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>

Comments (7)

  1. virbhadra

    Can you please provide what specific version do I need to check out. I tried below command which return error and also tried direct Hg cloning.

    pip install -e hg+https://bitbucket.org/openpyxl/openpyxl@2.5#egg=openpyxl
    

    error.PNG

  2. virbhadra

    Hi Charlie,

    Can you please respond to my question above, I believe the latest version that you have is 2.5.0a3 from checkout. which I have already tried.

    Thanks,

    Vir

  3. Log in to comment