Bug 133760 - Large file when saving from CSV file to XLSX or ODS
Summary: Large file when saving from CSV file to XLSX or ODS
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.0.alpha1+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-07 16:21 UTC by Telesto
Modified: 2020-09-03 17:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file (9.46 MB, application/zip)
2020-06-07 16:22 UTC, Telesto 		Details
ODS of the same data (3.09 MB, application/vnd.oasis.opendocument.spreadsheet)
2020-06-07 16:22 UTC, Telesto 		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 Telesto 2020-06-07 16:21:47 UTC 
Description:
Large file when saving from CSV file to XLSX or ODS

Steps to Reproduce:
1. Open the attached CSV
2. Save as ODS or XLSX -> File around 23 MB

Actual Results:
File around 23 MB

Expected Results:
3,9 MB


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.0.0.alpha1+
Build ID: 82b773b43291024e9e854c9371016236e58f550c
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Telesto 2020-06-07 16:22:31 UTC 
Created attachment 161733 [details]
Example file
Comment 2 Telesto 2020-06-07 16:22:58 UTC 
Created attachment 161734 [details]
ODS of the same data
Comment 3 Xisco Faulí 2020-06-09 12:12:17 UTC 
(In reply to Telesto from comment #0)
> 
> Expected Results:
> 3,9 MB

based on what ?
Comment 4 Telesto 2020-06-10 05:10:03 UTC 
(In reply to Xisco Faulí from comment #3)
> (In reply to Telesto from comment #0)
> > 
> > Expected Results:
> > 3,9 MB
> 
> based on what ?

1. Open attachment 161734 [details]
2. File save as CSV
3. Save cell formula's instead of calculated value's checked (not sure if it matters, didn't check)
4. File reload
5. Save as ods
6. Compare size source ods with the newly saved file
Comment 5 Buovjaga 2020-09-03 17:26:03 UTC 
(In reply to Telesto from comment #4)
> (In reply to Xisco Faulí from comment #3)
> > (In reply to Telesto from comment #0)
> > > 
> > > Expected Results:
> > > 3,9 MB
> > 
> > based on what ?
> 
> 1. Open attachment 161734 [details]
> 2. File save as CSV
> 3. Save cell formula's instead of calculated value's checked (not sure if it
> matters, didn't check)
> 4. File reload
> 5. Save as ods
> 6. Compare size source ods with the newly saved file

The size is the same, 3 MB for me after step 5. Am I missing something?

The CSV in your zip file is like 45 MB.

Arch Linux 64-bit
Version: 7.1.0.0.alpha0+
Build ID: 2db30aa0206ca3d9d5a665d550820d8fcbcff4b9
CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 3 September 2020
Comment 6 Telesto 2020-09-03 17:42:53 UTC 
They comparison file is at least not right.. no memory what I was doing back then