Removing hidden sheet damages xlsx file.
Created originally on Bitbucket by Yahor Tsyplakou
Condition - template (excel document for editing) has two sheets - hidden first and usual second. After removing hidden sheet (no matter sheet_state
was or wasn’t changed) the document is saved without any warnings. Upon opening result document (in Microsoft Excel 2013) - it said that document was damaged and offer to restore it. After restoring columns width, rows heights and cells styles settings are reset.
Attachments: DamagedResult.xlsxExample.xlsx