Description: LibreOffice: 6.3.6.2 Mac OS: 10.15.5 I have a relatively large spreadsheet file (~300 columns x ~150 rows) created by hand to track meals I've had. I've used it for years. It grows slowly. Starting within the last few months, anytime I do a "find" action on the spreadsheet, LibreOffice crashes. Facts: - It did not happen months ago. I think it's unlikely that my minor hand-edits of the document in the last few months introduced an issue in the document. It's likely a change in LibreOffice. I have not attempted to revert to a version that works. (My computer is managed and I do not have a setup where I can install arbitrary software of arbitrary versions.) - This crash is reproducible. LibreOffice always crashes when I try the find "action". - The crash happens regardless of whether the text I'm looking for is present in the document ("pizza") or not ("asiuvkljssl"). - The crash happens if LibreOffice is launched in safe mode. - The crash does not happen on my other spreadsheet files. - I have not tried reproducing on other platforms. I would appreciate a fix for the bug, as it's hard to navigate a spreadsheet this large without searching. I am willing to share the spreadsheet with interested LibreOffice contributors. However, I do not want to post it publicly, which is why I'm not attaching it here at this time. Steps to Reproduce: 1. Open the spreadsheet in question. 2. Press control-f or select Edit -> Find 3. Type something in the box and press enter or click the magnifying glass icon. Actual Results: 4. LibreOffice crashes and offers to restart and recover the file. (It does this successfully.) Expected Results: 4. LibreOffice scrolls to the cell that has the matching text. Reproducible: Always User Profile Reset: No Additional Info: Nothing to add.
I could take a look at it if you send the document to me. But maybe you could try replacing all characters in your file with some single character (or two), to make it anonymized, test that it still crashes, and then post it right here.
Could you give a try at LO 6.4.4 + https://wiki.documentfoundation.org/QA/FirstSteps ? Have you got accessibility issues: 1) Do you have any accesibility features enabled? Apple’s accessibility features like “VoiceOver” or “Enable access for assistive devices”, which get enabled in “System Preferences > Universal Access”, are known to cause many crashes and freezes in LibreOffice. So please try to disable any accesibility features, then check if the problem is still reproducible. 2) Do you have installed any window management/user interface utilities/apps/control panels/extensions for Mac OS X like * AquaSnap * BetterSnapTool * BetterTouchTool * Breeze * Cinch * Divvy * DoublePane * Flexiglass * HyperDock * iSnap * Moom * RightZoom * ShiftIt * SizeUp * SizeWell * Spectacle * Stay * TileWindows * WindowTidy * Flavours (from flavours.interacto.net) ... or something similar? And/or do you use any mouse cursor/pointer utility, i.e. some little application or control panel etc. which animates or replaces etc. the mouse curser/pointer, like * LazyMouse? And/or do you use any special software which could be related to accessibility stuff, e.g. a screen reader, screen magnifier, speech recognition software, a text-to-speech (dictation) application, or similar? All these and many similar utilities rely heavily on Mac OS accessibility features and therefore can cause LibreOffice to crash or freeze. So please check if you have installed any utility of this kind and try to disable it (or to add LibreOffice to the list of excluded applications for the utility, if there is such a thing). So please check these possibilities, if any of them helps to make the crash go away, and report the results here. If you still reproduce this, would it be possible you attach a backtrace/stacktrace ? (see https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#macOS:_How_to_get_debug_information)
Good news! Per comment 2, I downloaded version 6.4.4.2. That works fine. This bug must've been fixed. Marking as fixed. Before I tried latest version, I tried all the other things suggested. For posterity, I post the answer I already wrote: re #1: I sent Mike Kaganski the spreadsheet. > But maybe you could try replacing all characters in your > file with some single character (or two), to make it anonymized I can't do this because find-and-replace crashes in the same manner that find does. re #2: > 1) Do you have any accessibility features enabled? Not as far as I know. I checked he accessibility features in system features and everything looks set to be the default (usually disabled, else the default value). I'm not aware of using any of such features. That said, this machine is machined by the company I work at, so it's possible they have something installed on it that I'm not aware of. > 2) Do you have installed any window management/user interface > utilities/apps/control panels/extensions for Mac OS X like > ... No, I don't have anything on that list. The only thing in that flavor I have installed is an app called "Watch". I tried disabling that. It didn't help. > And/or do you use any mouse cursor/pointer utility, i.e. some > little application or control panel etc. which animates or replaces > etc. the mouse curser/pointer, like > * LazyMouse? Not as far as I know. > And/or do you use any special software which could be related to > accessibility stuff, e.g. a screen reader, screen magnifier, speech > recognition software, a text-to-speech (dictation) application, or > similar? Not as far as I know. > If you still reproduce this, would it be possible you attach a > backtrace/stacktrace ? (see > https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#macOS:_How_to_get_debug_information) I don't see how. When the app crashes, I get a screen window title: LibreOffice 6.3 Document Recovery Due to an error, LibreOffice crashed. All the files you were working on will now be saved. The next time LibreOffice is launched, your files will be recovered automatically. The following files will be recovered: ... In other words, this crash doesn't result in the crash message "LibreOffice quit unexpectedly.” / report to Apple. I'm not sure why. (Do you have different possible ways of handling crashes?) Give nthat I don't see the "report to Apple" screen, I don't know how to get a stack trace. I will note that I wouldn't be surprised if, for confidentially reasons, my company has disabled the "report to Apple" functionality on this machine.
Adjusting resolution as per comment 3, since the specific commit that fixed the problem is unknown. Thank you for the report! >> But maybe you could try replacing all characters in your >> file with some single character (or two), to make it anonymized > >I can't do this because find-and-replace crashes in the same manner that find does. Oh that was a stupid thinko from my side :-)