Bug 52029 - FILESAVE very slow save and very big output for a very simple .xlsx file
Summary: FILESAVE very slow save and very big output for a very simple .xlsx file
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.5.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-12 20:35 UTC by macska
Modified: 2013-12-09 14:51 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
this is the problematic file (549.31 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-07-12 20:35 UTC, macska 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description macska 2012-07-12 20:35:59 UTC 
Created attachment 64153 [details]
this is the problematic file

I have a little xlsx file made with MS Office, which takes about 15-20 seconds to save in LibreOffice. It basically has a SUM formula, some formatting and numbers.

I also noticed that the previously small file becomes gigantic (550K) after saving. For example, empty worksheets have a very big xml file in /xl/worksheets/.  Even if a row is empty, a <row> tag is created for it. Thus, 65536 empty rows are written in the xml file. (Note that this behaviour may probably indicate a bug, because the maximum number of rows supported is one million.)
Comment 1 Noel Grandin 2012-09-05 09:25:51 UTC 
Tested in 3.6.1.2 (Windows)