It seems to crash (throws an exception and shuts down) when I'm working on larger files and have neglected to save (I have to save every couple of edits). It's particularly bad if I am editing a large formula or a block of data. I'm presently working on a file is 1.37 MB and this is particularly bad and frustrating. I'm not au fait with the code but it behaves like there is some sort of stack or memory overload -- there is no particular action that throws the crash, it just happens when I have done too many edits without saving. Over time, it becomes more and more sensitive. The original file was an xls, so I though that storing that format in memory was the problem, so I saved to ods. Unfortunately, it didn't fix the problem at all. Love the interface and the clean layout and arrangement. Would love to ditch MS completely but this bug is getting in the way now.
Hello, Thank you for reporting the bug. Unfortunately without clear steps to reproduce it, we cannot track down the origin of the problem. Please provide a clearer set of step-by-step instructions on how to reproduce the problem. Please attach a sample document, as this makes it easier for us to verify the bug.(Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
1) 4.4.0.3 is the first version of brand new 4.4 branch. So it's not for production. 2) 4.4.1 has been released recently, it could help you upgrade LO version 3) For the test, please rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#Mac_OS_X. Indeed, there might be bugs in some extensions or buggy remnants of former LO versions. If you've got regular crashes, think about making backup of your files, it may help.
Created attachment 113871 [details] Very large file containing complex data on people's livelihoods To reproduce the bug: Using the attached file, open a cell like CU90 on the "Data" sheet (the sheet may need to be unprotected. Do the edit by sliding the group of cells in each Count($T90:$AJ90) expression Count($AL90:$BB90). Do this repeatedly, without saving the file, on a number of cells in Row 90 from CU to DK and keep repeating the same in Row 91 until the software crashes. Sometimes Calc is good and doesn't crash easily, sometimes it crashes on each edit. Another thing that seemed to cause crashes is adding columns. Try doing this to the sheet.
I'll work some more with the uploaded document or a very similar one, and if the crash occurs again, I will immediately try to reproduce it, then will file the steps to you. I cannot find it now and Calc is behaving well. Will try to assist as best I can on this.
I'm downloading 4.4.1 and I will use that. If the bug reappears on that version, I will report it here. If not, I will add a note to that effect below so you can close it off. Thanks for the response.
(In reply to chezearth from comment #3) > Created attachment 113871 [details] > Very large file containing complex data on people's livelihoods > > To reproduce the bug: > > Using the attached file, open a cell like CU90 on the "Data" sheet (the > sheet may need to be unprotected. Do the edit by sliding the group of cells > in each Count($T90:$AJ90) expression Count($AL90:$BB90). Do this repeatedly, > without saving the file, on a number of cells in Row 90 from CU to DK and > keep repeating the same in Row 91 until the software crashes. Sometimes Calc > is good and doesn't crash easily, sometimes it crashes on each edit. > > Another thing that seemed to cause crashes is adding columns. Try doing this > to the sheet. Tested on Win & Linux. I don't know what sliding means, so I just manually edited a Count($T90:$AJ90) instance to Count($AL90:$BB90). I did this in 5 different cells. I also inserted several columns. No crash observed. Win 7 Pro 64-bit, LibO Version: 4.4.1.2 Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale: fi_FI Ubuntu 14.10 64-bit Version: 4.4.1.2 Build ID: 40m0(Build:2) Locale: en_US
Let's put it as WFM for the moment. Chezearth: don't hesitate to reopen this tracker if you reproduce it with 4.4.1.
Seems to have been resolved, thank you.