https://bugs.documentfoundation.org/show_bug.cgi?id=171907
--- Comment #3 from ady <[email protected]> --- There are more than enough reports about the increased size of (xlsx) files when re-saving them from Calc. The typical workaround is: 1. Open the original worksheet. 2. [CTRL]+[END] 3. [Down_arrow] (first unused row) 4. [SHIFT]+[Space_bar] (select entire row) 5. [CTRL]+[SHIFT]+[Down_arrow] 6. [CTRL]+[-] (delete unused rows) 7. [CTRL]+[END] 8. [Right_arrow] (first unused column, for the typical LTR worksheets) 9. [CTRL]+[Space_bar] (select entire column) 10. [CTRL]+[SHIFT]+[Right_arrow] (for the typical LTR worksheets) 11. [CTRL]+[-] (delete unused columns) Repeat the procedure for each worksheet in the same workbook, and "save as" the file (with a new name, for comparison and to keep the original file). The size of the resulting new file should be (much) smaller than without the workaround. Warning: Please keep in mind that the "unused area" in the above procedure could potentially be not really unused – it has no content, but it could still have some formatting, or some feature other than content. So, it is up to _you_ to decide which area is to be considered as "unused" and whether to apply the workaround (or not). At any rate, this report could probably be set as a DUPE of many others, perhaps adding some info about the XML "dimension" details. Alternatively, someone with the relevant knowledge should rather take this specific report and actually improve the situation. There is possibly some reason for the (XML) "dimension" to be "too big(?)" when saving in Calc. -- You are receiving this mail because: You are the assignee for the bug.
