[upstream] Poor performance with find & replace with empty value on large data set
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Medium
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Seyeong Kim | ||
Trusty |
Fix Released
|
Medium
|
Unassigned |
Bug Description
[SRU justification]
[Impact]
Hang or Very slow performance after replaceall or searchall massive data
Regression in Find and Replace with LO Calc 4.2 (last worked in 4.1). It now takes a long time to "Find and Replace" if the to be replaced is to nothing.
See comment #5/#6 of upstream for reproducer.
See commend #8 for bibisect.
[Test Case]
fill A column to 0
select A column
Replace All 0 to " " ( null space )
[Regression Potential]
restricted, relevant patches are currently:
- upstream master
- all upstream 4.4.0 alpha/beta builds
- upstream 4-4 branch
- backported (by me) to upstream 4-3 branch
=> thus also included in upstream 4.3.5~rc1 released on November, 27th
=> thus will also be released by upstream 4.3.5 on ~December, 18th
- backported to 4.3.4/utopic package (downstream, Ubuntu only)
- backported to 4.2.7/trusty package (downstream, Ubuntu only)
- included in all current 4.3.x and 4.2.x backports in the LibreOffice PPAs
- included in all the 4.4~beta1 builds on the LibreOffice prereleases PPA
[Other Info]
upstream patch
http://
http://
http://
description: | updated |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Confirmed |
Changed in libreoffice (Ubuntu): | |
status: | New → Triaged |
importance: | Undecided → Medium |
description: | updated |
Changed in libreoffice (Ubuntu): | |
status: | Triaged → In Progress |
Changed in libreoffice (Ubuntu): | |
status: | Fix Committed → In Progress |
description: | updated |
Changed in df-libreoffice: | |
status: | Confirmed → Fix Released |
Changed in libreoffice (Ubuntu): | |
status: | Fix Committed → Fix Released |
Changed in libreoffice (Ubuntu Trusty): | |
importance: | Undecided → Medium |
Problem description:
Steps to reproduce:
1. Open on .ods file in Calc with large amount of data, e.g., 584 columns & 755 rows
2. Run Search & Replace to replace contents of ~20% of cells
3. Program freezes, requires a kill process (TERM command) to unfreeze
Current behavior:
So, that's one way to describe the issue in operationalizable terms, but it's really that when a large file is opened, many operations in Calc can be _greatly_ lagging. E.g., scrolling right through columns can start to lag behind a continually-pressed key (viz., right arrow) such that Calc takes several seconds to catch up after the key is let up. I'm not in any way a programmer, but seems like maybe an issue of how objects are held and manipulated in memory?
In a sense, I'm asking for a lot (and, yeah, sorry but probably through a very poorly-submitted & -formatted bug report; this isn't my bailiwick), but, yeah, I _do_ ask a lot of the spreadsheet program of an office suite. I believe it's where most people make their decision about what office suite to use. Word processors, presentation software, etc. are simpler and usually contain less importantly rich information that needs quicker processing.
Expected behavior:
Faster responsiveness on larger files. Perfection right now! : )
Oh, and maybe knowing (& finding out how to) better submit bug reports and help improve LO qua end user.
Operating System: Ubuntu
Version: 4.2.3.3 rc