After upgrade to Ubuntu 19.10, Libreoffice 126.96.36.199, 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
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)
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?
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
=> 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.
Tony: taking a look at tdf#128946, I wonder if it may be already fixed on master branch.
*** This bug has been marked as a duplicate of bug 128313 ***