Bug 128925

Summary:	CALC freezes after search Find & Replace in "Current Selection Only"
Product:	LibreOffice	Reporter:	Tony <tony>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	serval2412
Priority:	medium
Version:	6.3.3.2 release
Hardware:	All
OS:	Linux (All)
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=128946
Whiteboard:
Crash report or crash signature:		Regression By:

Description Tony 2019-11-20 19:40:05 UTC

After upgrade to Ubuntu 19.10, Libreoffice 6.3.3.2, 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 ***