Created attachment 126260 [details] Chart of Solar Output: Day_Plot and Smoothed Plot I have a Calc Workbook with many entries. When I edited the Formulae in a certain column to compute on about 95 values everything seemed to work that day but when I tried to re-open the file to that page the next day Windows shut down LibreOffice with the message. LibreOffice has stopped working correctly. Windows will close the program.... The File can be recovered but if I attempt to save it the same thing happens. The computer is running Windows 7. I then upgraded LibreOffice from 5.1.4.1 to 5.1.4.2 but the same thing happens. I went back to an earlier copy and updated it. All seemed well but the next day the same problem. I copied the problem file to a USB stick and can use it with no problems in my Dell Precision M6400 laptop computer which I recently upgraded to Windows 10 but left Libre Office 4.0.4.2 on it. Both computers are running 64-bit versions of Windows. So it appears that LibreOffice 5 cannot process a file that LibreOffice 4 has no problems with. Any suggestions? The file was created in LibreOffice, always saved in OD format and I have not allowed any MS Office program to touch that file. I have made two test files by deleting most of the worksheets. The one I upload contains the graphs which are the purpose of the calculations. Data to be displayed is selected in A2: the weighting factor in A3. A value of 1.00 on A3 would result in a simple averaging. The calculations produce the thick line which is a weighted-toward-the-centre average of the values plotted with a thin line. LO 5 crashes when the "Solar" worksheet containing the graph is selected. I created another from this file by deleting the graph. LO 5 opened that one but crashed when I attempted a Save-As on it. The test files were created using LO 4.
Unconfirmed with v5.1.5.1 under windows 7 x64. Try resetting the userprofile and see if it helps: https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile
Renamed user profile but no difference. (Except that I had to tell Calc. where to find the file.)
Not reproduced with LibreOffice 5.1.4.2 x86 / Windows 7 x64. Please try first with 'Tools -> Options... -> LibreOffice -> OpenCL -> Allow use of OpenCL' unchecked, if that doesn't help, also uncheck 'Allow use of Software Interpreter (even when OpenCL is not available)' (restart of LibreOffice is required in both cases). If neither helps, could you give the 5.2 pre-release version a try (accessible from the download page)? It includes a crash reporter function, which catches and uploads crash dumps, and could provide important details for developers. If you don't want to disrupt the existing LibreOffice installation, here are instructions on installing multiple versions separately: https://wiki.documentfoundation.org/Installing_in_parallel .
Thanks Aron. The first suggestion appears to be working. OpenCL is now not allowed and no crashes so far. I copied the up-to-date version of the original file from the other computer. Loaded it. Modified it. Saved it. Exited LibreOffice. Restarted LO and opened the file again all with no problems. Have not yet checked all functionality of the other sheets.
Great! Would you mind giving it a try with the 5.1.5.1 pre-release version? (with OpenCL enabled) There have been a couple of fixes in that area. Here are details on installing different versions in parallel with your existing installation: https://wiki.documentfoundation.org/Installing_in_parallel .
Hmmm. The one I found was 5.2.0.2 I just upgraded to it. It is not that difficult to uninstall and put the older version back. 5.2.0.2 appears to work very well. Everything recalculating quickly and correctly. (I have often had to force recalculation with earlier versions.) Until I enable openCL again. Then Windows closes LO as before when I attempt to open the file. Does that help you? I can try again with 5.1.5.1 if you think they are different enough to warrant the effort.
Yes, please test with 5.1.5.1, because 5.2.0.2 was released before those fixes. You can also find current pre-releases here: http://dev-builds.libreoffice.org/pre-releases/ See this and subsequent comments for details on a similar issue: https://bugs.documentfoundation.org/show_bug.cgi?id=100545#c15 In short, what should happen is that if something is wrong with the OpenCL implementation, it should be disabled automatically.
5.1.5.1 Works with or without openCL enabled. A separate issue, using a single quote at the start of a number ('65635 because I want it treated as text) is treated differently in my LO5 and in the 5.1.5.1 version I used just now. In 5.2.0.2 that worked properly again, as in 4.0.4.2 and earlier. In 5.1.x.x I have to copy another cell to where I want the new value then backspace out the unwanted number and type in the new one else my lookups do not work on the new (account) number. The difference is very visible in the cell. I did not ask about that earlier as I had changed computers and thought that might be the problem. But 5.2.0.2 worked so I doubt that it is the hardware. Hope the feedback is some help. Thank you for yours.
Thanks for the report Laurie - we fixed this in 5.1.5.1 for you then; and also 5.2.0 and for 5.3 with the on-start OpenCL validation. Please could you file this new issue separately ? Thanks !
Laurie, thanks for the feedback! Michael, since there's no commit attached to the report, adjusting status to RESOLVED WORKSFORME.
The single quote problem appears to not be a new issue. Added a comment to bug 73377.