Bug 100283 - FILESAVE some XLSX documents created by LO are much larger than created by Excel
Summary: FILESAVE some XLSX documents created by LO are much larger than created by Excel
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-08 23:39 UTC by Bartosz
Modified: 2020-09-16 15:25 UTC (History)
1 user (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 Bartosz 2016-06-08 23:39:05 UTC 
Some XLSX documents created by LO are much larger than created by Excel.

The root cause of problem is that Excel is using default values more widely.
Example of styles for Excel:

<xf numFmtId="0" fontId="0" fillId="0" borderId="0"/>
<row r="1" s="2" customFormat="true" ht="18.15" hidden="false" customHeight="true" outlineLevel="0" collapsed="false">

The same style created by LibreOffice:

<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="true" applyBorder="false" applyAlignment="false" applyProtection="false"/>
<row r="1" s="2" customFormat="true" ht="18.15" hidden="false" customHeight="true" outlineLevel="0" collapsed="false">


To resolve that issue I would propose to use default values for storing values.
Comment 1 Bartosz 2016-06-08 23:46:59 UTC 
Review with changes for reducing size of xlsx documents:
https://gerrit.libreoffice.org/#/c/26079/
Comment 2 jani 2016-06-09 05:46:18 UTC 
Copying comments from markus from gerrit #26079

Using default values is not a good idea. We try to be explicit with all default values to avoid issues with wrong default values.
Some versions of LibO and Excel have the wrong default value handling.
Comment 3 hppyromz 2020-05-13 09:30:37 UTC Comment hidden (spam)
Comment 4 jameswell 2020-05-27 11:20:50 UTC Comment hidden (spam)
Comment 5 pragya.uproi 2020-09-16 02:54:33 UTC Comment hidden (spam)
Comment 6 ashish gtm 2020-09-16 15:25:51 UTC Comment hidden (spam)