If I open an XLSX file, make a change (any change will do, eg. change the content of a cell), save it and reopen the document (closing Calc or just close the document and reopen it), all column sizes in all tables across the document will shrink.
This happens throughout all versions since v. 6.2.8
Thank you for reporting the bug.
Please attach a sample document, as this makes it easier for us to verify the bug.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 156591 [details]
Testfile created with Exel and edited with LO demonstrating the bug
Changes made to this document make the columns shrink.
Xlsx you attached is wrong, because it's already modified by LO.
We need source Xlsx from Excel (as in other cases source Ods from LO).
Let me add that we had similar big fixed for LO 5.3. If you have just LO-modified Xlsx before that. All details may be relevant. Bug is only if we reproduce from Excel ource Xlsx.
This is the only file I can provide because I don't use Microsoft Office anymore and neither do I have it installed or a license for it.
I first opened the file in LO 6.3.3.
But still - it is a bug. Whether LO corrupted the file with a previous bug or it is a current bug during the import. The file is corrupted in any way and there is no way for me now to fix that.
I already had to remove almost all conditional formatting because LO showed empty cells at some random point in time, but there is no obvious workaround for this bug is there?
Even though source is not proper, I tested with LO 6.2.8, 6.3.3 and 6.5+ in Windows and couldn't reproduce.
So I'll close.
When reporting a bug, there's a question if you tried with User Profile Reset.
Seems you skipped that. And that's what you should try.