Hidden columns not always working
Created originally on Bitbucket by gradgrind (Michael Towers)
Hiding columns in an existing document leads to a resulting xlsx where some “hidden” columns are visible and other “non-hidden” columns are hidden, when the result is viewed in LibreOffice (I can’t test in Excel) or Planmaker. If I hide the columns in LibreOffice or planmaker, the column data looks quite different in the sheet.xml extracted from the xlsx archive. The outputs of LibreOffice and Planmaker look correct when viewed in the other program.
The original file is test.xlsx. The other xlsx files are the outputs from the various programs.
The “cols_” files are extracts from the sheet.xml files within the xlsx archives.
Attachments: cols_libreofficecols_planmakertest.xlsxtest_openpyxl.xlsxtest_planmaker.xlsx