Bug 71943 - Crashes intermittently when adding a formula to a cell
Summary: Crashes intermittently when adding a formula to a cell
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-11-23 16:47 UTC by David Lynch
Modified: 2015-01-11 23:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Spreadsheet that exhibits this bug (1.21 MB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-23 16:47 UTC, David Lynch

Note You need to log in before you can comment on or make changes to this bug.
Description David Lynch 2013-11-23 16:47:03 UTC
Created attachment 89687 [details]
Spreadsheet that exhibits this bug

I have  a fairly large and very complex spreadsheet (attached):

Number of sheets 12
Number of cells 123562
Number of pages 55

size 1.23 Mb

much calculation (typically about 200 cells aren't formulas) and many array formulas.

Often, but not always, when I add a formula to this spreadsheet, CALC crashes saying Calc has an unexpected error and is saving. I can then recover the spreadsheet and adding the new formula now works. There appears to be no dump or other information to aid diagnosis. 

LibreOffice crashed with the attached spreadsheet and message.
Due to an unexpected error, LibreOffice crashed. All the files you are working on will be saved now. The next time LibreOffice is launched, your files will be recovered automatically.
This was run from a command prompt: there were no messages in the command prompt.

Before the crash, I entered the formula:
into cell W.J36.

It crashes only when I add a formula and enter it (and not always then).

I recovered the spreadsheet and re-entered the formula: this time it worked.
I am running on Windows.
These are my memory options:
Undo Number of steps 20
Graphics cache
Use for LibreOffice 256MB
Memory per object 5.0 MB
Remove from memory after 00:10 hh:mm
Cache for inserted objects
Number of objects 50
Comment 1 m_a_riosv 2013-11-23 19:56:00 UTC
Hi David,

I can't reproduce de crash, but if I understand right the issue appears after a while working with the file, maybe is in relation with bug:
Comment 2 David Lynch 2013-11-23 22:46:19 UTC
It might be related but, as far as I can see, bug 71409 does not cause a crash. But this bug, 71943, does

David Lynch
Comment 3 David Lynch 2013-12-12 21:56:17 UTC
LO is still crashing frequently because of this bug. (No work is lost, LO recovers the data.) 

I have tried running from a console, but I don't seem to get any additional information.

I have attached a file exhibiting the bug, but others cannot make LO crash.

Is there a way in which I could provide you with more evidence of this bug?
Comment 5 Yousuf Philips (jay) (retired) 2014-06-02 05:47:45 UTC
Hi David,
Which version of windows were you running that caused the crash? Does it need to be complex formulas that crash it?
Comment 6 David Lynch 2014-06-03 15:58:28 UTC
Hi David,
Which version of windows were you running that caused the crash? 

I was running Windows XP SP2.

Does it need to be complex formulas that crash it?


The crashes occur only on spreadsheets with many complex formulas. They occur *only* immediately after hitting enter on a formula: the formula being entered does not have to be complex.

The spreadsheet can be recovered. After recovery, re-entering the same formula that caused the crash does *not* cause a crash. A crash will recur only after working on the spreadsheet for some time after recovery.

The hardware on the machine exhibiting this bug is unreliable (it refuses often to reboot). I now have a Windows 8.1 machine. I have seen this bug on the Windows 8.1 machine, but it is much rarer.

David Lynch
Comment 7 Yousuf Philips (jay) (retired) 2014-06-05 00:08:44 UTC
Unfortunately, i've tried to crash the attached file on Windows XP SP3 with adding various small calculations across the spreadsheet but it didnt happen. Its difficult for us to reproduce a crash that only happens some of the time, as you stated. Please try upgrading to 4.1.6 or 4.2.4 and see if the same crashes happen. I'd advice upgrading XP to SP3 as well. With 4.2.4, you will be able to send us a backtrace using the information found at < https://wiki.documentfoundation.org/How_to_get_a_backtrace_with_WinDbg >.
Comment 8 QA Administrators 2015-01-10 18:06:25 UTC
Dear Bug Submitter,

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 INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 

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

Message generated on: 10/01/2015
Comment 9 David Lynch 2015-01-11 23:15:33 UTC
Since 75971 has been fixed, I haven't seen this bug. I suspect that 71943 and 75971 are duplicates.
Comment 10 Yousuf Philips (jay) (retired) 2015-01-11 23:51:45 UTC
Setting as WFM then. :D

Thanks David for the confirmation.