I have a spreadsheet which, when I attempt to open it, crashes LibreOffice. This happened a few weeks ago. I was told to install the latest version. I did so, & the file opened. It opened again a few times. Now this is happening again, with the same file. It begins to open, opening a window, then just goes away, also removing any other LibreOffice windows I may have open. It leaves behind the .lock file. I can't really upload a copy of the file, as it contains personal financial information. I haven't seen this with any other LibreOffice files. This bug is a real pain, & it seems that no one is trying to fix it. I need to be able to access the data in this file. I entered this somewhere the first time around, but I can't find it to reference it. Searching finds so much stuff I may be missing it.
As is we can not do anything with this issue because it is not reproducible for anyone else. But, if you can install the 5.2.0.2 rc2 build of LibreOffice, that should automatically catch the crash of Calc with correct debug detials. It will give you the option of uploading the crash report and allow us to see of what is happening. Other than that--if you prefer to stay with a 5.1.x build, you need to clear your user profile and check stability with and without OpenGL support enabled (done from Tools -> Options -> View: check box "Enable OpenGL for all rendering (on restart)"
Unchecking 'Tools -> Options... -> LibreOffice -> OpenCL -> Allow use of OpenCL' and 'Allow use of Software Interpreter (even when OpenCL is not available)' might also be worth a try. I added the earlier bug report in the see also field. You can find your own bugs via Search/Advanced Search, locate Search by People section, then in one of the columns have Reporter checked, and add either your e-mail address or %user% (if you're logged in) in the text field. Also make sure to select all Resolutions, otherwise only the unresolved bugs will be returned.
Yes, I know that non-reproducible bugs are hard to fix. I can try the rev you specify, but . . . the last time I was told to up-rev, & it seemed to resolve the problem, only to have it recur later after the bug had been closed. As I say, I'd attach the spreadsheet if it weren't a lot of financial information. And of course that might not help anyway. Also, is the debugging information (when & if) going to include data from the spreadsheet? If so, I really don't want to be sending it. I tried all 4 variations on checking the two OpenGL boxes; LibreOffice still crashed (all windows of whatever type vanishing) every time I tried to open this file. I don't have a clue what "clear your user profile" means or how to do it; I couldn't find anything in the tools that said that, although there's so much stuff I could easily be missing something obvious. I will try installing the rev you specified. If crashes then continue, & if I can inspect the crash report, & it doesn't include a bunch of data, I'll upload it. Thanks. <sigh>
Hmm. I guess I won't download it. I can't find out how. If I go to libreoffice.org, it offers me the chance to download 5.1.4. I'm currently on 5.1.3.2, so I could try uploading to this. If I click down below, I can get to a page that offers me source code in tarballs; I don't think I have what's needed to build it. It also offers me a button "DOWNLOAD VERSION 5.2.0". If I click that, it starts to download LibreOffice_5.2.0.2_Win_x86.msi . But you specified "5.2.0.2 rc2". Nothing tells me how to get that or whether that's what I'd be getting. You'll understand that I hesitate to install a pre-release version if it's not the one that will give the desired information. I'm sorry, I'm a user in this case, not a developer, & I really don't want suddenly to find (say) that I can't open any files at all, or something like that. (And, yes, things like that have happened to me in the past.) So I guess I need more complete instructions.
Please also try my earlier suggestion as well, uncheck these, and restart LibreOffice: 'Tools -> Options... -> LibreOffice -> OpenCL -> Allow use of OpenCL' and 'Allow use of Software Interpreter (even when OpenCL is not available)' Do this first before downloading any newer release. Version "5.2.0.2" is the same as Stuart mentioned (the .2 at the end stands for rc2). I'm not entirely sure the crash reporter would be able to catch this particular kind of crash, but it's certainly worth a try if the above suggestion doesn't help (if it does, no need to bother). If you're going to install a newer version, you can also install it separately from the existing installation, there are some directions here: https://wiki.documentfoundation.org/Installing_in_parallel/Windows (SI-GUI is a useful little tool)
@Dave, * Clearing your user profile to allow a new default to build is trivial--details are here: https://wiki.documentfoundation.org/UserProfile The 5.2.0.3 rc3 builds have just posted here: http://dev-builds.libreoffice.org/pre-releases/ These builds include the built-in crash reporting mechanism that would be very helpful to resolving this. The automated crash reporting performs a program mini-dump based on the Google "breakpad" project crash reporting (don't implement OS X flavor). It does not upload without your permission, and shall not upload any of the document details--only the program stack and details useful for debugging an issue. =-ref-= https://sourceforge.net/p/google-breakpad/wiki/GettingStartedWithBreakpad/
Thank you. I've tried deleting the profile directory, starting LibreOffice, resetting the "Use OpenGL for all rendering (on restart)" box, closing & reopening LibreOffice. I've tried this with the box both checked & unchecked. None of that accomplishes anything useful; LibreOffice closes all windows as soon as I try to open the offending spreadsheet. Thank you also for the explanation for what version I should download & where I can get it. I will try this when I have a little more time.
Dave, I had a different suggestion, it's not related to OpenGL, but OpenCL (they're different things), and note that the setting is different as well.
Aron, Thanks for clarifying that; I had definitely missed the difference between OpenGL & OpenCL. Sorry to be so long in trying it! And it appears to work. At least, after I uncheck both of those & restart LibreOffice, I can now open the offending spreadsheet file. I have to say, though, that when I first had this problem (see https://bugs.documentfoundation.org/show_bug.cgi?id=100504 --- was that REALLY only a month ago???) the file opened after I installed a new rev, only to have this start again a week or two ago. So I guess the comment I posted then is actually still appropriate: "Since I don't know why LibreOffice was crashing, I don't know whether this is a fluke or whether the problem is fixed." And, since I don't really understand what OpenCL is & does, & why it's there in the first place, I don't know whether I'm letting myself in for later problems by leaving it turned off. (I did search for & read some things on OpenCL; I'm just too ignorant to know whether I really need it.) But in any case, thanks very much. (I see that you (Aron) were the one who patiently helped me the last time, too.)
Dave, I'm glad this workaround solved the issue for you. The only purpose of OpenCL is to speed up calculation on formulas depending on large data sets, utilizing the GPU's compute capabilities. It should work without any awareness and interaction from the user, unfortunately some vendor driver versions have issues that manifest in mysterious crashes. (and sometimes LibreOffice has issues as well) There's nothing to worry about having it disabled, and the upcoming LibreOffice releases (5.1.5 and 5.2.0) will have further measures to check the drivers early, and disable OpenCL if there are problems. So in the future these kinds of bugs will be avoided, hopefully. I'm closing this as WORKSFORME. If you encounter similar issues in the future, return status to UNCONFIRMED.