Bug 103920 - Writer slow and not responding when you delete columns from XLSX with 28101 lines
Summary: Writer slow and not responding when you delete columns from XLSX with 28101 l...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Cell-Add-Delete
  Show dependency treegraph
 
Reported: 2016-11-14 07:29 UTC by Yasin Eyigun
Modified: 2024-02-09 21:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Crash file (1.94 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-11-14 07:31 UTC, Yasin Eyigun
Details
ods save of xlsx-file in 6.4.1.2 (536.15 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-03-09 22:48 UTC, paulystefan
Details
save old xlsx file in newer actual Excel-2016 xlsx Status 2020 (1.85 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-03-09 23:14 UTC, paulystefan
Details
ods save of xlsx-file of newer excel 2016 in 6.4.1.2 (566.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-03-09 23:18 UTC, paulystefan
Details
newer actual Excel-2016 xlsx reduced 5120 lines (355.07 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-03-10 00:32 UTC, paulystefan
Details
newer actual Excel-2016 xlsx reduced 4096 lines (283.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-03-10 00:34 UTC, paulystefan
Details
newer actual Excel-2016 xlsx reduced 4944 lines (340.51 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-03-10 13:39 UTC, paulystefan
Details
newer actual Excel-2016 xlsx reduced 4930 lines (339.83 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-03-10 14:15 UTC, paulystefan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yasin Eyigun 2016-11-14 07:29:28 UTC
Description:
It closes when you delete columns from a file with 28101 lines.

Actual Results:  
Any

Expected Results:
Open


Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: tr
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
Builds ID: LibreOffice 5.2.3.3


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.71 Safari/537.36
Comment 1 Yasin Eyigun 2016-11-14 07:31:23 UTC
Created attachment 128738 [details]
Crash file
Comment 2 Aron Budea 2016-11-15 01:21:58 UTC
Reprdouced wtih 5.2.3.3 and 4.1.0.4 / Windows 7.

Spreadsheet takes quite long to open. I tried deleting column B, a merged column. Memory usage started rising rapidly, and at around 1.6 GB LibreOffice crashed.
Comment 3 QA Administrators 2017-11-16 09:22:54 UTC Comment hidden (obsolete)
Comment 4 Xavier Van Wijmeersch 2017-11-16 15:06:28 UTC
reproduce with, but no crash

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Spreadsheet opens normal. I tried deleting column B, a merged column. Memory usage started rising rapidly, 6.5GB and freezing the system. Have to kill the application and with

Version: 6.0.0.0.alpha1+
Build ID: 831dca83f073bca9ad6242f1b96183eb4a49af69
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-11-15_00:06:28
Locale: nl-BE (en_US.UTF-8); Calc: group

also using all ram and swapping a lot. Needed to kill the application to.
Comment 5 arthur13 2018-11-29 08:35:43 UTC
Bug not reproducible in version
Version: 6.3.0.0.alpha0+ (x64)
Build ID: 0f25a3c36f27fd51453b9a9115f236b83c143684
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-11-27_20:06:55
Locale: zh-TW (zh_TW); UI-Language: en-US
Calc: threaded
Comment 6 QA Administrators 2019-11-30 03:40:00 UTC Comment hidden (obsolete)
Comment 7 paulystefan 2020-03-09 22:35:56 UTC Comment hidden (obsolete)
Comment 8 paulystefan 2020-03-09 22:44:56 UTC Comment hidden (no-value)
Comment 9 paulystefan 2020-03-09 22:48:51 UTC Comment hidden (no-value)
Comment 10 paulystefan 2020-03-09 22:51:02 UTC
improvement from 6.3.5.2 to 6.4.1.2

faster first load of file as xlsx and ods
Comment 11 paulystefan 2020-03-09 23:05:36 UTC Comment hidden (obsolete)
Comment 12 paulystefan 2020-03-09 23:11:17 UTC Comment hidden (no-value)
Comment 13 paulystefan 2020-03-09 23:14:06 UTC Comment hidden (no-value)
Comment 14 paulystefan 2020-03-09 23:18:43 UTC Comment hidden (no-value)
Comment 15 paulystefan 2020-03-10 00:27:34 UTC
with reduced file to 5120 lines 

delete column B

fatal message of LO 6.4.1.2

could not create system bitmap!


file with only 4096 lines 

delete of column B is ok
Comment 16 paulystefan 2020-03-10 00:32:06 UTC
Created attachment 158534 [details]
newer actual Excel-2016 xlsx reduced 5120 lines

delete of column b 

fatal message LO 6.4

could not create system bitmap!
Comment 17 paulystefan 2020-03-10 00:34:59 UTC
Created attachment 158535 [details]
newer actual Excel-2016 xlsx reduced 4096 lines

no crash with 4096 lines
with delete column B

so the limit is between 4096 and 5120 lines of this action in file

for create system bitmap!
Comment 18 paulystefan 2020-03-10 13:30:54 UTC
limit is in files between 
4928 and 4960 lines. 

4928 lines are ok after delete column b

4960 lines are too much.
 
fatal message 
could not create system bitmap!
Comment 19 paulystefan 2020-03-10 13:39:41 UTC
Created attachment 158552 [details]
newer actual Excel-2016 xlsx reduced 4944 lines

4944 lines other are deleted in excel 2016 before.

delete column B in LO 6.4.1.2

crash without message.

with 4960 lines the crash is with message 
can not create system bitmap

with 4920 lines no crash, all ok
Comment 20 paulystefan 2020-03-10 14:15:35 UTC
Created attachment 158554 [details]
newer actual Excel-2016 xlsx reduced 4930 lines

here 4930 lines other are deleted in excel 2016 before.

delete column B in LO 6.4.1.2

warm crash without message. LO windows long frozen. some pixels on down border.

4932 lines crash without message, LO windows go down.
4944 lines same like 4932

with 4948 lines the crash is with message window
can not create system bitmap!

with 4929 lines no crash, all ok
Comment 21 paulystefan 2020-06-22 00:07:34 UTC Comment hidden (obsolete)
Comment 22 Timur 2020-06-23 09:41:12 UTC
@paulystefan@web.de: You are making a lot of tests but writing it wrong, as your notes, instead of comment for others. Please don't, you are making bug hardly readable. Instead, do all tests you want and then write a single clear comment.

I lower the importance because XLSX is specific per comment 9 and MSO 2016 opens it very long, with final error.
Comment 23 paulystefan 2021-05-17 14:54:09 UTC
deletion of row 

works for me with crash file and newer mso 2016 file

Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
Comment 24 Timur 2021-05-18 10:39:57 UTC
Repro in 7.2+, Writer is slow and not responding for a while after column delete. 
That's the same as in 6.4, only we need to wait.
Comment 25 Roman Kuznetsov 2021-12-05 21:26:31 UTC
I tryied to delen a Column B in the Crash file and got a crash really in

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 2934472ab888ebfe64a153984af2902fac63a7a0
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

Unfortunately, still repro
Comment 26 QA Administrators 2023-12-06 03:17:52 UTC Comment hidden (obsolete)
Comment 27 Tex2002ans 2024-02-09 21:35:01 UTC
Got a crash report:

- https://crashreport.libreoffice.org/stats/crash_details/61d41f26-7607-48b6-87d5-fcab2dbc0f6d

All I did was:

0. Open "Crash file" = attachment 128738 [details].
1. Select column B.
2. Right-Click > Delete Columns.

LibreOffice sat there for a ~15 seconds, using a full CPU, then just closed itself.