Bug 133759 - Memory usage XLSX 896 MB, same data as XLS 130 MB
Summary: Memory usage XLSX 896 MB, same data as XLS 130 MB
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Memory
  Show dependency tree / graph
 
Reported: 2020-06-07 16:08 UTC by Telesto
Modified: 2020-10-19 07:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
XLS (11.28 MB, application/vnd.ms-excel)
2020-06-07 16:09 UTC, Telesto 		Details
XLSX (zipped) (9.79 MB, application/zip)
2020-06-07 16:10 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:08:43 UTC 
Description:
Memory usage XLXS 896 MB, same data as XLS 130 MB

Steps to Reproduce:
1. Open the attached file & check memory usge

Actual Results:
XLXS 896 MB
XLS 130 MB

Expected Results:
Somewhere around 130


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

also in
3.3.0
Comment 1 Telesto 2020-06-07 16:09:34 UTC 
Created attachment 161731 [details]
XLS
Comment 2 Telesto 2020-06-07 16:10:55 UTC 
Created attachment 161732 [details]
XLSX (zipped)
Comment 3 Telesto 2020-06-07 16:25:38 UTC 
This file is an odd product of bug 133760
Comment 4 Buovjaga 2020-10-18 11:37:11 UTC 
I confirm it, but it is a bit problematic to define this without any specifics. I also tested with MSO 2013 and it has a difference as well. ~30MB with XLS and ~150MB with XLSX. The formats are different after all, so it is not a suprise that there is a difference in mem use.
Comment 5 Buovjaga 2020-10-19 07:20:24 UTC 
Thanks to Mike Kaganski for spotting: the XLS has 64k rows while XLSX has 500k. Closing.