Description: Calc crashes and freezes the computer when doing random actions such as trying to enter data or even viewing the "About LibreOffice" in Help. I cannot identify any specific action that is causing the problem. Other running programs also become frozen but Task Manager usually opens and will kill the Libre Calc program. The file then can be recovered. I had the same problem with 6.2.6. Older versions such as 5 did not have this issue. It may occur if the file has been edited but not saved but I am not certain about this. Steps to Reproduce: 1.Problem too random and can't be reproduced. 2. 3. Actual Results: Computer freezes. Expected Results: Not freeze computer Reproducible: Couldn't Reproduce User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Windows 7 Home Premium OS is 64bit: no
Please test Menu/Help/Restart in Safe Mode.
I have disabled Open CL and Hardware Acceleration and LibreOffice seems to be working much better and faster. It has not yet crashed and frozen the computer.
[Automated Action] NeedInfo-To-Unconfirmed
xtr806595, you say you *had* the same with 6.2.6. What's your version now? Please try to pinpoint is it Open CL and Hardware Acceleration? We need specific steps and concrete document or steps when crash happens. https://wiki.documentfoundation.org/QA/BugReport Also please try https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile
When issue is described, we ask you to download and test master dev version https://dev-builds.libreoffice.org/daily/master/ that will install separately from your working version.
The version is 6.2.7.1 as I stated in the bug description. I have re-enabled Open CL but left Hardware Acceleration disabled and so far there have been no crashes or freezing of the computer.
(In reply to xtr806595 from comment #6) > The version is 6.2.7.1 as I stated in the bug description. I have re-enabled > Open CL but left Hardware Acceleration disabled and so far there have been > no crashes or freezing of the computer. Could you please confirm enabling the Hardware Acceleration makes the issue to reapper?
I re-enabled hardware acceleration and the problem reappeared. The program seems to work OK with just Open CL enabled. The freezing problem occurs after the values in several cells have been edited but the sheet not saved.
(In reply to Timur from comment #5) > When issue is described, we ask you to download and test master dev version > https://dev-builds.libreoffice.org/daily/master/ that will install > separately from your working version. Can you please download and test master dev version 6.4+?
I am still having trouble with computer freezing even with Hardware Acceleration, CL and GL all disabled. I have updated to version 6.3.3.2 and the problem is still there. If a Writer document is open at the same time, that freezes also. I don't know if it is relevant but the files that I have been using when the computer freezes are password protected. I also use Firefox and that is often open at the same time and also crashes when Libre freezes. I have not had the opportunity to try 6.4. The problem is random but seems to occur after an edit that has not been saved.
That files affected have password protection is probably important. Please help us by testing more and finding if it's just some password protected files or all. Can be done if you create a similar file with arbitrary content. Aim is to have reproducible steps and that you attach here a file that causes the problem. If new file doesn't reproduce, please remove personal info from the existing (by changing content), make sure it still causes the trouble and attach it.
I don't see any comment about the issue persist after Menu/Help/Restart in Safe Mode with a clean profile.
I have refreshed the profile using Safe Mode but the problem still persists. I cannot reliably reproduce it and the file that I am working on when the freezing occurs has too much private information to remove for sharing. It still seem to occur when I have edited several cells but not yet saved the changes. The only other thing I have noticed is that Firefox is also open when the freezing occurs but this may be just a coincidence. Libre version still 6.3.3.2
Stupid bot change from Needinfo is wrong. We must have reproducible steps. Please do as in Comment 13. You are advised to remove personal info, like replacing all chars with x. Even better to reduce document to minimal where issue occurs.
Created attachment 158707 [details] Process Monitor screen print The freezing of my computer with the freezing of Calc is ongoing. It only occurs when I have edited information in the spreadsheet but not yet saved the changes. I originally thought it was related to Hardware Acceleration or CL but it is not. It does seem to occur when I have Libre Calc and Firefox running at the same time, but this may be a coincidence. I have run Sysinternals Process Monitor and found that the program feezing seem to be soffice.bin. Soffice.bin seems to become frozen with the information of "Name Collision". The following is part of the report. "16/03/2020 1:42:45.1492082 p.m. soffice.bin 8272 CreateFile C:\Users\Roger\AppData\Roaming\LibreOffice\4\user\backup\1RTT stock portfolio - Latest.xlsx_4376.ods NAME COLLISION Desired Access: Generic Read, Disposition: Create, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a, ShareMode: Read, Write, AllocationSize: 0" The computer keeps trying to do something with repeated effect as above. The part "4376.ods" continues to count up until I kill the process, in this instance it became "4581.ods" when I killed the process. I have attached a screen print of the Process Monitor display just before I used Task Manager to kill soffice.bin.
Is it just "password protected" or any files? Please search for "autosave" bugs.
I have identified the problem causing my computer to freeze when using Calc. The problem is with the Save AutoRecovery information feature. If this is enabled the program tries to save information in the default backup folder but fails to correctly do so. Instead it saves a numbered zero byte file and continues to save a similar file with a new number every few seconds. The freezing was caused because the default backup folder had become full with over 23,000 of these zero byte files and would not take any more causing the program to freeze. I have deleted all 23,000 files in the backup folder and disabled the Save AutoRecovery information setting which stops the attempts to write files to the backup folder. The program now functions normally and does not freeze. There is no loss in not having the Save AutoRecovery feature enabled as it was not saving any usable information anyway. I have enabled the "Always create a backup copy" setting and this functions correctly as it should.
See bug 118639
(In reply to Telesto from comment #22) > See bug 118639 Hello xtr806595@xtra.co.nz, Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ? You can install it alongside the standard version. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
It's always better to test with daily master, but in this case it's enough to simply upgrade to 6.4.last to see if fix in bug 118639 resolves this.
I have upgraded to version 6.4.4.2 and the bug is no longer there. All saving and deleting of Auto Recovery files in the back up folder now seems to be working correctly.
(In reply to xtr806595 from comment #25) > I have upgraded to version 6.4.4.2 and the bug is no longer there. All > saving and deleting of Auto Recovery files in the back up folder now seems > to be working correctly. Please mark it as resolved. RESOLVED WORKSFORME