Title of existing charts get broken
Hi there,
when editing an existing excel spreadsheet all my charts are missing their titles after saving with openpyxl.
the code to reproduce:
import openpyxl fName = "C:/tmp/myxls.xlsx" wb = openpyxl.load_workbook(filename=fName) ws = wb.worksheets[0] ws.cell(row=1,column=1).value = 1 wb.save(filename=fName)
I'm using a workbook with 2 worksheets. changes are only made to Worksheet 1, but diagram on Worksheet 2 is effected (see attached screenshot). The excel version used is 2016
Can you please look into this and maybe fix it?
Thank you and best regards,
Marcel Pinnow