opening and saving certain Excel Sheets in OpenPyXL corrupts them and strips their formatting
Created originally on Bitbucket by Robert L (Rob Letzler)
I notice this bug using certain XLSX files created in Nuance PowerPDF 1.2. (yes, PowerPDF 1.2 is not the latest. It’s also what I have a license to) Colorful_pages4 is an example; it comes from Colorful_pages4.pdf which I created using Excel 2016 and MS Print to PDF. When I open and save them in OpenPyXL (see test_case.py), and then open them in Excel 2010 or 2016, Excel reports that they are corrupted and their formatting is gone (an example of this output is in colorful_pages_openpyxl.xlsx). If I open the same files first in Excel and save them, then OpenPyXL handles them correctly (see colorful_pages4_after_saving_in_excel.xlsx and colorful_pages4_after_saving_in_excel_and_openpyxl.xlsx).
Attachments: colorful_pages_openpyxl.xlsxcolorful_pages4.pdfcolorful_pages4.xlsxcolorful_pages4_after_saving_in_excel.xlsxcolorful_pages4_after_saving_in_excel_and_openpyxl.xlsxtest_case.py