This bug was filed from the crash reporting server and is br-a45914cc-154c-4c85-beb0-0239f590dd4a. ========================================= The file is a very large one; see stats below. The autocalculate has been turned off, due to the size. The error is that Calc crashes when the recalculate (F9) is used. The fix is to turn off the Save AutoRecovery. This makes me think the bug is that the "Save AutoRecovery" has too high a priory and crashes during recalculation as both actions can't proceed at the same time. File stats; 4 sheets Sheet 1: Raw data in 4 columns x 669600 rows, formulas in 20 columns x 669600 rows Sheet 2: only formulas in 15 columns x 4480 rows (summarising data in sheet 1) Sheet 3: Raw data used as setting approx 50 cells Sheet 4: Formulas in 7 columns x 33 rows used to produce 2 graphs (further summarisation of sheet 1) Recalculation takes 15 minutes approx. Data is electric used and generated over the month in 4 second slots.
Can the document be shared publicly?
Created attachment 159974 [details] Testcase; follow instruction to run To see the system crash open the file and one the "Adjusted" sheet copy the cells E116 to Y116 to cells E117 to Y648037. Making sure the autorecovery is on press F9. It takes about 5 minutes to crash; the calculations take about 20 minutes to complete.
(In reply to gavinbstrange from comment #2) > > ... open the file and one the "Adjusted" sheet copy the > cells E116 to Y116 to cells E117 to Y648037. What is the easy way to do this? My usual "select and drag down" approach is taking ages.
The easiest way is to 1. select the cells E116 to Y116 and copy (cntl c). 2. select cell E117. 3. use the scroll bar to quickly move to the bottom of the sheet. 4. while pressing the shift button on the keyboard select cell Y648037. this should highlight all the cells between. 5. paste (cntl v) hope this is helpful. Gavin
(In reply to gavinbstrange from comment #4) > The easiest way is to > 1. select the cells E116 to Y116 and copy (cntl c). > 2. select cell E117. > 3. use the scroll bar to quickly move to the bottom of the sheet. > 4. while pressing the shift button on the keyboard select cell Y648037. > this should highlight all the cells between. > 5. paste (cntl v) Thanks, I gave it a try, but got my LO hang instead of crash. It stuck at "Saving File..." and the green progress bar at the status bar for about 5 minutes until I forced it to quit manually. Will try again later, with maybe fewer rows, my computer is likely less powerful than yours.
Could I check that you are using version 6.4.2.2. On previous version of LibreOffice (6.3.n), LibreOffice would hang, as you have described. It is only the later version that seems to crash. In terms of PC power, it also does it on my old Intel i5 (2 core) laptop with 8GBs of memory.
I *think* I've reproduced this. My system got very slow and non-responsive (moving the mouse and the cursor won't move), eventually after like 10 minutes (I pressed Ctrl-Alt-Delete to try to get to the Resource Mannager during this), LO was gone and my system got responsive again. But I didn't get any information about crash report even if I made sure I enabled it before started testing. (In reply to gavinbstrange from comment #6) > Could I check that you are using version 6.4.2.2. On previous version of > LibreOffice (6.3.n), LibreOffice would hang, as you have described. It is > only the later version that seems to crash. I was using 6.4.3 last time and 6.4.4 RC1 this time. Since I don't have a crash signature to compare with, I'm not marking this as CONFIRMED yet.
(In reply to gavinbstrange from comment #4) > The easiest way is to > 1. select the cells E116 to Y116 and copy (cntl c). > 2. select cell E117. > 3. use the scroll bar to quickly move to the bottom of the sheet. > 4. while pressing the shift button on the keyboard select cell Y648037. > this should highlight all the cells between. > 5. paste (cntl v) > > hope this is helpful. > Gavin I did all the steps, it hangs for a long moment (~20-30 minutes), then became usable, hangs again for a long moment... Surprise! Windows crashed O_o All I got is a screenshot of process explorer (see attachments), no crash report generated. Version: 7.0.0.0.beta1 (x64) Build ID: 94f789cbb33335b4a511c319542c7bdc31ff3b3c CPU threads: 4; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win Locale: fr-CH (fr_FR); UI: en-GB Calc: threaded
Created attachment 161981 [details] process explorer
(In reply to libre officer from comment #8) > (In reply to gavinbstrange from comment #4) > > The easiest way is to > > 1. select the cells E116 to Y116 and copy (cntl c). > > 2. select cell E117. > > 3. use the scroll bar to quickly move to the bottom of the sheet. > > 4. while pressing the shift button on the keyboard select cell Y648037. > > this should highlight all the cells between. > > 5. paste (cntl v) > > > > hope this is helpful. > > Gavin > > I did all the steps, it hangs for a long moment (~20-30 minutes), then > became usable, hangs again for a long moment... Surprise! Windows crashed O_o > > All I got is a screenshot of process explorer (see attachments), no crash > report generated. > > > Version: 7.0.0.0.beta1 (x64) > Build ID: 94f789cbb33335b4a511c319542c7bdc31ff3b3c > CPU threads: 4; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: > win > Locale: fr-CH (fr_FR); UI: en-GB > Calc: threaded Erratum: After clicking on save -> "hangs again for a long moment"
Hello, Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Dear gavinbstrange, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear gavinbstrange, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp