Description: Crashes every time I search for "simon", tried 4 times, let LibreOffice recover my files. Tried searching for "other text", also crashed. This is (for me) a large spreadsheet with 14 tabs, many of them cross-linked. Prior to search I entered numbers into a few cells and date/times into a few cells on the same sheet. After repeatable crashes, I tried to search for "stuff" and "times" on another sheet, it worked as expected, no crash. "stuff" not found, "times" found. Tried to search "stuff" on the problem sheet ("Next") and LibreOffice crashed again. The "Next" sheet has hundreds of formulas, several text boxes, many small graphics, lots of formatting, 922 KB. Recovery doesn't fix the bug, but it does seem specific to the one sheet. Not sure how to re-recreate the sheet, so I'll export it to another program when I need to do a search. Running Windows 10/64 Home on Dell XPS 8910 with 16 GB RAM, SSD & 2 HDDs, core i7 6700 (not overclocked), 2047MB NVIDIA GeForce GTX 750 Ti (NVIDIA). Using Bitdefender antivirus, other programs running: Free Commander XE (file manager), Macro Recorder (Bartels Media Gmbh), Clipdiary (clipboard manager), Genie Timeline, Google Chrome (one page open before crashes, now three). Pretty much my standard starting environment. This was all a few minutes after turning on my PC from power off state. Last time I tried the search (this is now 5 or 6 consistent crashes), after LibreOffice recovered the file, it opened at 75% size instead of my usual 110% size. Seems like corruption in the sheet is spreading.... Steps to Reproduce: 1.Open spreadsheet 2.Press Ctrl/F or click in the Find box 3.Enter text in Find box 4.Press Enter key Actual Results: LibreOffice 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: Expected Results: Cursor should move to a cell containing the searched text, or search text should turn red if it's not contained in a cell on the sheet. Reproducible: Always User Profile Reset: No Additional Info: About LibreOffice LibreOffice The Document Foundation Version: 6.3.6.2 (x64) Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497 CPU threads: 8; OS: Windows 10.0; Ul render default; VCL: win; Locale: en-US (enJJS); Ul-Language: en-US Calc: threaded See Log: 2196df99b074d8a661f4036fca8fa0cbfa33a497 LibreOffice is a modern, easy-to-use, open source productivity suite for word processing, spreadsheets, presentations and more. This release was supplied by The Document Foundation. Copyright © 2000-2019 LibreOffice contributors. LibreOffice was based on OpenOffice.org. ------------------- When I click on "See Log: ....", a page opens in Chrome listing a bunch of different topics from 4 months ago or more, not what I expected to see: https://git.libreoffice.org/core/+log/2196df99b074d8a661f4036fca8fa0cbfa33a497 Sorry, I don't know if OpenGL is enabled, wasted over an hour trying to figure that out. The OpenGL Viewer program says it needs a reboot and then I would have to type all this information in again. I tried running in LibreOffice Safe Mode, same problem, crash when I search for text. Tried opening a different file altogether, no crash. I'm assuming it's a corruption in my file that causes the crash, don't know what would have caused that. File has been edited most days for almost 2 years, I frequently delete sheets or sections of sheets that I no longer need.
Could you give a try with 6.4.5 + try https://wiki.documentfoundation.org/QA/FirstSteps ?
I replied to an email about this bug report, which asked me to try something. Nowhere in the email did it say not to reply. Rejection email said, "Recipient address rejected: You replied to a Bugzilla notification email. However email replies are not added to bug reports." No where did Julian's email say to reply in the Bug Reporting system, or how to do that, or how I should respond. So I'm adding my email below, and hope my frustrations can find their way to someone who can change things: Hello Julian, thank you for the very quick response. I didn't expect to hear anything at all! I installed 6.4.5.2 and that appears to have fixed the issue I had this morning. When I first saw the crashes, my first question was if a new version of LibreOffice was available. So I went to Help, Check for new version, and got the message that 6.3.6 is up to date. My mistake, I thought that meant no new version is available, so I didn't look for one. I guess it means, there is no new version of the version I already have, so it's fairly useless and misleading in my opinion. Also, when the program asked me to submit a bug report, why didn't it take me to the page your link leads to, "First steps to take before submitting a bug report"? I would have seen right away that a newer version existed. Altogether I spent about 10 hours trying to write the bug report, figure out what Open GL is running, if any (still don't know that one), checked my LO User Profile (worked the same in LO Safe Mode), searching the internet for posts about similar issues, explored .ods file components after unzipping them, checking other spreadsheet files, and trying to repair my file by copying sheet contents to new tabs and manually fixing hundreds of links (Search & Replace had the same issue as Search). I think your bug was related to sheets with formulas linking to other sheets within the same file. A file saved last June had the same problem, so that told me it was a software issue -- I _know_ I've done searches since then. I later realized I installed 6.3.6 only a few days ago, maybe a week, so that version introduced the bug into my workflow. So while I'm happy the problem is resolved, and happy for your support, I'm not happy that most of my wasted time could have been avoided if the "Check for new version" worked like it does in most (all?) other programs, and if your bug report process at least offered an obvious link to "First steps to take". So I hope you can get word to the right development people. My experience today will discourage me from recommending LO to others, and I came very close to deleting the program from my PC. A help process should consider that users don't know everything developers know. Even the bug report option to pick what kind of system I have... There's no option I can find relating to a 64 bit x86 system (NOT the same as IA64, I did some research on that also). So I picked "Other" even though I have what is probably the most common PC system type out there. "All" didn't seem appropriate. I don't know how you use this information but your most common case can't be identified and that simple menu cost me about 15 minutes. "See log" in Calc's About box was also quite unhelpful, it looked like a log of old unrelated issues, not a log of what happened on my PC. If it's some sort of change log, say so in the About box. From an end-user perspective, LibreOffice and its support websites are very difficult to figure out. I still don't understand why Cutting/Pasting a group of cells in Calc has different results than dragging the cells to a new destination. Things change by themselves over time, like formulas containing named references -- another name gets substituted in formulas I didn't change. Basics just don't seem to work consistently. For some context: I've been using computers since 1975, developed many applications and automations in MS Office/VBA and ran the IT group at a GE facility. The IT groups in two other companies I worked for told me I know more about IT than they did, and I was called in to help them several times, even though my background is Industrial Engineering. So I wish you the best of luck and again, thank you for your help. I've been too lazy to switch products but today made me realize I've been letting hope get in the way of reality for LibreOffice. On Tue, Aug 11, 2020 at 3:57 PM <bugzilla-daemon@bugs.documentfoundation.org> wrote: Julien Nabet changed bug 135643 What Removed Added Ever confirmed 1 Status UNCONFIRMED NEEDINFO CC serval2412@yahoo.fr Comment # 1 on bug 135643 from Julien Nabet Could you give a try with 6.4.5 + tryhttps://wiki.documentfoundation.org/QA/FirstSteps ? You are receiving this mail because: You reported the bug. -- mrdave740@gmail.com (primary) mrdave740@yahoo.com (if other address not working)
[Automated Action] NeedInfo-To-Unconfirmed
mrdave740: Update process concerns only the branch you are. In 6.3 branch there's indeed no other updates after 6.3.6. For technical details required for a report, if you don't know, you can let the default values. About "logs", I don't see it on LO Debian package 7.0.0.2 but I must recognize I don't use much this part. For the rest, we don't need you to spill your frustration and report even more bugs. I'm just a benevolent and know that there are thousands of bugs in LO. Nobody forces you to use LO so if you're unhappy, uninstall it, spit on it if you want and use MsOffice, Google docs, Apache Openoffice or whatever. Heiko/Xisco: I noticed some interesting points in last reporter comment. 1) It could be interesting that bugzilla notifications indicate to respond on Bugzilla instead of responding in private. For example with a signature at the end of each notification like this: "Please respond on Bugzilla by using https://bugs.documentfoundation.org/show_bug.cgi?id=135643# for a comment only or https://bugs.documentfoundation.org/attachment.cgi?bugid=135643&action=enter for an attachment and a comment" 2) We should make the link https://wiki.documentfoundation.org/QA/FirstSteps more visible in a way, perhaps in https://wiki.documentfoundation.org/QA/BugReport or directly in https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice ? 3) About updating, it could be useful to have a message than a newer version exist but in a more recent branch. Finally, since the bug doesn't appear on 6.4.5, let's put this one to WFM.