Pivot chart get modified after saving XLSM file
Created originally on Bitbucket by Ignacio C
I’m using Python 3.8.2 and Openpyxl 3.0.3.
After saving an XLSM file with a Pivot Chart, I found 4 different visual issues on the chart:
- Buttons on top of vertical axis disappeared
- Button below of vertical axis disappeared
- First value of references area dissapeared
- First value of horizontal axis dissapeared
This issue didn’t happen when I used the same file but converted to XLSX.
The command used to open the workbook is:
For XSLM file:
wb = openpyxl.load_workbook('Before saving.xlsm', keep_vba = True)
For XLSX file:
wb = openpyxl.load_workbook('Before saving.xlsx')
Please find the screenshots and the example XLSX and XLSM file attached.
Attachments: XLSM_-_After_saving_IssuesXLSM_-_After_saving.xlsmXLSM_-_Before_saving_no_issuesXLSM_-_Before_saving.xlsmXLSX_-_After_saving.xlsxXLSX_-_Before_saving.xlsx