Bug 128925 - CALC freezes after search Find & Replace in "Current Selection Only"
Summary: CALC freezes after search Find & Replace in "Current Selection Only"
Status: RESOLVED DUPLICATE of bug 128313
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2019-11-20 19:40 UTC by Tony
Modified: 2019-11-23 08:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Tony 2019-11-20 19:40:05 UTC
After upgrade to Ubuntu 19.10, Libreoffice, on a Thinkpad, this bug appeared: 

when searching (Find & Replace) with a column selected and "Current selection only" by mistake was NOT checked, the first click on "Find next" goes well but with the second click, Calc freezes. The mouse still works but I can't switch to other applications using alt-tab. After a few minutes the force quit/wait pop up appears but doesn't reacht for another couple of minutes. 

Same as above but "Current selection only" checked, then Calc freezes too but I can switch to other applications and kill libreoffice.

When nothing is selected and "Current selection" not checked then everything works normal. 

This is all on a powerful Thinkpad. I am highly dependent on multiple searches like that which are restreicted to one column. Please help, thanks! Hope I gave enough information
Comment 1 Julien Nabet 2019-11-21 07:53:10 UTC
On pc Debian x86-64 with master sources updated today, I don't reproduce this.

Do you reproduce this on a brand new file with a column some numeric values only?
If no, would it be possible you attach an example file?
(if possible and not blocked because of this bug, you may need to sanitize it, see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission)
Comment 2 Tony 2019-11-21 11:03:05 UTC
Hi Julien, I have tried it with a new calc file and same problem. Though I managed to narrow down what causes it. it only happens if the entire column is selected (ctrl-space) if I select the filled cells only with a a small number of rows like 10) it doesn't happen. I am working on a file with 7000 rows and if I select row 1 to 7000 and not the entire column, the search becomes very slow (10 seconds) even if the next cell with the searched content is in the row below, whereas in the version before the search result and being taken to the cell with the found content was instant.

also if you search for something that doesn't appear even once in the selected area, running the search the 2nt time will not result in this problem. the searched term needs to appear at least once.

do you still need the sample file?
Comment 3 Julien Nabet 2019-11-21 16:06:16 UTC
On Win10 with master sources updated today, here what I did:
- launch Calc with a brand new file
- on column B, I filled 7000 cells from 1 to 7000
- put several cells at 1
- select B column
- Ctrl-H
=> Search/Replace dialog appeared
- Typed 1 in "Search" part
- clicked "Next search"
=> no freeze (as expected)
- clicked "Next search" a second time, then a third time
=> no freeze

Did I miss something?
I'd be interested you attach an example file.
Comment 4 Julien Nabet 2019-11-22 09:02:42 UTC
Tony: taking a look at tdf#128946, I wonder if it may be already fixed on master branch.
(see https://bugs.documentfoundation.org/show_bug.cgi?id=128946#c1)
Comment 5 Mike Kaganski 2019-11-23 08:45:56 UTC

*** This bug has been marked as a duplicate of bug 128313 ***