Bug 73994 - FILESAVE: 1 MB XLSX grows to 12 MB upon save as ODS
Summary: FILESAVE: 1 MB XLSX grows to 12 MB upon save as ODS
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.3 rc
Hardware: x86-64 (AMD64) Windows (All)
: highest major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-01-23 21:34 UTC by squeezechart
Modified: 2021-05-04 13:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
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 squeezechart 2014-01-23 21:34:58 UTC 
Opening this XLSX and saving it as ODS is working, but
the 1 MB XLSX grows to a 12 MB ODS after saving process is done.
Looking in the .ODS tells me the XML part is way larger than in original.

You can download the XLSX here:

http://www.squeezechart.com/SqueezeChart2013-preview.xlsx
Comment 1 m_a_riosv 2014-01-27 09:34:32 UTC 
I think there is a lot of link, maybe is the same issue than this:
https://bugs.freedesktop.org/show_bug.cgi?id=74090
Comment 2 squeezechart 2014-01-27 10:33:39 UTC 
The links were also imported in earlier versions of LibreOffice (4.1x)
with the ODS file having roughly the same size as the XLSX.
Comment 3 tommy27 2014-01-28 01:12:53 UTC 
tested under Win7 64bit

original XLSX filesize is 668 KB
ODS output is 5.81 MB with 4.2.1.0+ (*) if I select "update links" and 10.94 MB if I select "don't update link"

using 4.1.4.2 the filesize is always 416 KB in both cases

add REGRESSION keyword.
set status to NEW. 
adding Calc expert to CC list.


(*) Build ID: 88cd9632e081f5839cf9fddf60cbff0c099e2968
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-01-09_22:46:56
Comment 4 Björn Michaelsen 2014-03-16 01:12:35 UTC 
Fix priority for MABs.
Comment 5 Michael Meeks 2014-03-26 18:21:11 UTC 
$ ls -lh /tmp/SqueezeChart2013-preview.xlsx /tmp/exported.*
-rw-r--r-- 1 michael users 375K Mar 26 18:19 /tmp/exported.ods
-rw-r--r-- 1 michael users 1.4M Mar 26 18:19 /tmp/exported.xlsx

-rw-r--r-- 1 michael users 669K Mar 26 18:17 /tmp/SqueezeChart2013-preview.xlsx

Hmm - our XLSX export increases it size somewhat - but the ODS is significantly smaller - at least when using master.

Can you provide a breakdown of the .zip file contents & their size to narrow down where the problem could be ?
Comment 6 Kohei Yoshida 2014-03-27 01:31:12 UTC 
(In reply to comment #1)
> I think there is a lot of link, maybe is the same issue than this:
> https://bugs.freedesktop.org/show_bug.cgi?id=74090

Yup, I think it was most likely caused by this above bug that ended up inflating the amount of hyperlinks.  With that bug fixed, the file size increase no longer happens.
Comment 7 Kohei Yoshida 2014-03-27 01:32:00 UTC 
This is no longer present.
Comment 8 todgas 2021-05-04 04:09:31 UTC Comment hidden (spam)