Using 'find' crashes Calc
Using 'find' crashes Calc
I've been using open office calc for many years with no problems, up to and including yesterday.
This morning I turned the computer on and every time I try to search using the 'find' searchbox calc crashes. It immediately goes through the reloading process and restarts but as soon as I search again, it crashes again.
I tried several different files, some that I use every day and some that I haven't opened in a few weeks. I tried creating a new file. Every one of them now crashes when I use 'find'.
I'm using Windows 11 home version 21H2. I downloaded and installed the latest version of open office (4.1.13) Previously I was using 4.1.07.
I tried renaming my user profile and creating a new one (saw this in a post from a few years ago). I haven't installed anything new.
I can search using the binoculars icon but this is inconvenient as I use 'find' dozens of times a day to search records.
Please, does anyone have a fix for this issue?
This morning I turned the computer on and every time I try to search using the 'find' searchbox calc crashes. It immediately goes through the reloading process and restarts but as soon as I search again, it crashes again.
I tried several different files, some that I use every day and some that I haven't opened in a few weeks. I tried creating a new file. Every one of them now crashes when I use 'find'.
I'm using Windows 11 home version 21H2. I downloaded and installed the latest version of open office (4.1.13) Previously I was using 4.1.07.
I tried renaming my user profile and creating a new one (saw this in a post from a few years ago). I haven't installed anything new.
I can search using the binoculars icon but this is inconvenient as I use 'find' dozens of times a day to search records.
Please, does anyone have a fix for this issue?
Last edited by Rhyssa6 on Sat Oct 01, 2022 10:52 am, edited 2 times in total.
Apache Open Office 4.0.1 AOO401m5(Build:9714) - Rev. 152495
Windows 8.1 64 bit
Windows 8.1 64 bit
- Hagar Delest
- Moderator
- Posts: 32655
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Using 'find' crashes calc
Very strange, not heard of that recently.
You can try LibreOffice, it is very similar to AOO. There are portable versions to make sure that it works better before deciding to switch to it.
You can try LibreOffice, it is very similar to AOO. There are portable versions to make sure that it works better before deciding to switch to it.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Using 'find' crashes Calc
This was reported a while back, and while some uers were able to replicate it, some were not.
One common work around was to use Ctrl+f rather than the search box.
One common work around was to use Ctrl+f rather than the search box.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Using 'find' crashes Calc
I tried copying some files to my other laptop which was running a much older version of OO (installed 2016). The search function doesn't work on it either, including on much older files that were already on that laptop.
I then uninstalled Apache OO and installed Libre Office on the old laptop. I can't even attempt to search in it as the 'find' icon is greyed out.
I then tried using find in a text document on my current laptop and it works in that.
'Find and replace' works in both Libre and Apache but I'm unable to use 'find' in any calc file using either Libre or Apache. It's like there's a hidden attribute "search" and it's been turned off on all my calc files.
I've added a sample file if anyone wants to try it.
Does anyone know of a different program I could try?
I then uninstalled Apache OO and installed Libre Office on the old laptop. I can't even attempt to search in it as the 'find' icon is greyed out.
I then tried using find in a text document on my current laptop and it works in that.
'Find and replace' works in both Libre and Apache but I'm unable to use 'find' in any calc file using either Libre or Apache. It's like there's a hidden attribute "search" and it's been turned off on all my calc files.
I've added a sample file if anyone wants to try it.
Does anyone know of a different program I could try?
- Attachments
-
- Sample.ods
- (35.86 KiB) Downloaded 67 times
Apache Open Office 4.0.1 AOO401m5(Build:9714) - Rev. 152495
Windows 8.1 64 bit
Windows 8.1 64 bit
Re: Using 'find' crashes Calc
I've now installed OnlyOffice and I can search spreadsheets using it. If I close the sheet and open it in Calc though it still doesn't work.
Apache Open Office 4.0.1 AOO401m5(Build:9714) - Rev. 152495
Windows 8.1 64 bit
Windows 8.1 64 bit
-
- Volunteer
- Posts: 255
- Joined: Tue Apr 18, 2017 8:23 am
- Location: Germany
Re: Using 'find' crashes Calc
Installed:
Version: 7.4.1.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: en-US
Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.20.04.1~lo1
Calc: threaded
No problem in finding "red" (one or each/all) on December sheet or "plum" on July sheet.
Recommendation: Version: 7.3.6.2 / LibreOffice
- Cheers
Version: 7.4.1.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: en-US
Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.20.04.1~lo1
Calc: threaded
No problem in finding "red" (one or each/all) on December sheet or "plum" on July sheet.
Recommendation: Version: 7.3.6.2 / LibreOffice
- Cheers
LibreOffice current versions 7 and OpenOffice 4.1.15
on LinuxMint 20 - 21 Mate, W10-64 pro
on LinuxMint 20 - 21 Mate, W10-64 pro
- Hagar Delest
- Moderator
- Posts: 32655
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Using 'find' crashes Calc
The search feature works also fine for me with LO 7.2.6.2 (portable) on Windows 10.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: [Solved] Using 'find' crashes Calc
I can't see the post that solved my issue?
Apache Open Office 4.0.1 AOO401m5(Build:9714) - Rev. 152495
Windows 8.1 64 bit
Windows 8.1 64 bit
- Hagar Delest
- Moderator
- Posts: 32655
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Solved] Using 'find' crashes Calc
I thought that OnlyOffice would do the job. You can remove the tag in your first post and set the icon to None.
If even resetting the profile doesn't work, I have no idea then.
If even resetting the profile doesn't work, I have no idea then.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: [Solved] Using 'find' crashes Calc
OnlyOffice is a temporary work-around until I find a fix for the problem. I still use calc for everything else and just use OnlyOffice when I need to do some searching.
Today I tried uninstalling Open Office (including user files and registry entries) and reinstalling, still no luck.
Today I tried uninstalling Open Office (including user files and registry entries) and reinstalling, still no luck.
Apache Open Office 4.0.1 AOO401m5(Build:9714) - Rev. 152495
Windows 8.1 64 bit
Windows 8.1 64 bit
- Hagar Delest
- Moderator
- Posts: 32655
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Solved] Using 'find' crashes Calc
Reinstalling won't change anything since all the user related configuration is in the user profile.
But if you've already reset it, then that's weird.
You can try the dev mailing list, maybe they heard about that.
But if it occurs also in LibreOffice, then it's even weirder...
But if you've already reset it, then that's weird.
You can try the dev mailing list, maybe they heard about that.
But if it occurs also in LibreOffice, then it's even weirder...
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10