Created attachment 114042 [details] Spreadsheet exhibiting bug I upgraded from 4.4.1.1 to 4.4.1.2 this week (on Windows 8.1). I have a fairly complex spreadsheet that worked well on 4.4.1.1. I hadn't changed it for several weeks. In 4.4.1.2: Whenever I try to add a column in sheet w (eg between G and H), Calc crashes with an "unexpected error" (no further detail). I can recover the file and usually a second attempt at adding a column works. Some formulae involving names give incorrect results (eg many cells in sheet a, a.EN2:EP513 contain "Error: No result"). If I rewrite them using A1:B2 notation they work. It is significantly slower. I have tried a new user profile and increasing the memory allocated, with no change in behaviour. Spreadsheet attached.
Reproducible with LO 4.4.1.2, Win 8.1, increased the importance due to crash of CALC
I have now had recovery fail after LO crashes. The message is "Unknown SEH exception"
Bug still present in 4.4.2
This seems to have begun at the below commit (on master, and the equivalent on the 4.4 stable branch). Adding Cc: to erack@redhat.com; Could you possibly take a look at this one? Thanks source-hash-47230a036fe35b9a7a7c0609232849fcbb51efcc commit 47230a036fe35b9a7a7c0609232849fcbb51efcc Author: Eike Rathke <erack@redhat.com> AuthorDate: Thu Feb 5 11:32:13 2015 +0100 Commit: Eike Rathke <erack@redhat.com> CommitDate: Thu Feb 5 11:52:51 2015 +0100 Resolves: tdf#88792 do not hold a ScFormulaCell** in group area listener ... as the mdds storage segment may change when a formula cell is inserted at a position such that two segments are merged into a new one. Change-Id: I449a89005418aff7ea12099ea931b786959dbc3b
That is odd, I would had expected it would crash without that commit ... I could reproduce a crash in master dbgutil on Linux. Taking.
Commit notification doesn't work.. I committed a workaround (not a real fix) to master to prevent the crash, http://cgit.freedesktop.org/libreoffice/core/commit/?id=cff5ee864b2d87d74079697425d7895dbf1b2ba4 Pending review for 4-4 at https://gerrit.libreoffice.org/15331
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5c6f7f0920a91c974e9639f2c751582c8f140b2b&h=libreoffice-4-4 tdf#89957 prevent crash, not really fixed It will be available in 4.4.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
It crashes in 4.4.3.2. The message is "Unknown SEH exception".
Could not reproduce in LO4.4.4.3 anymore. Seems to be fixed. (Kubuntu 14.04 LTS 64-Bit)
I confirm Papamatti's finding that the bug seems to have been resolved. In addition: the spreadsheet runs faster, at least twice as fast. intermittently, I was having to [CNTL][Shift][F9] to get a result in a cell, this also seems to have been solved. Many thanks to those that solved this. For the last three months or so, it has taken me about quarter of an hour to add a column to my application.
Please don't set this bug to resolved fixed, it is not, only the crash is prevented, the underlying cause is not fixed. Thank you.
Created attachment 117199 [details] Spreadsheet crashing in 4.4.4.3
My spreadsheet has crashed, copy attached. No error message other than "unexpected error". It has crashed only once in 4.4.4.3. It did so frequently in 4.4.4.2.
@David: Crashed when doing what when where?
Entering a formula in an existing cell, I think =LEFT(A2)="*" in w.Q2 I had this behaviour frequently some time ago, ie crash from entering a formula in an existing cell, but recently only adding a new column caused a crash.
I am now getting a crash consistently when I try to enter the string "nw cell" into cell fq.an1 Usually it just crashes with no message. Once it hung, and once it gave the error message "SEH exception: ACCESS VIOLATION" I attach the spreadsheet exhibiting this behaviour. Version: 4.4.4.3 Build ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8 Locale: en_GB Windows 8.1
Created attachment 117336 [details] Spreadsheet exhibiting crash when altering cell fq.an1
(In reply to David Lynch from comment #15) > Entering a formula in an existing cell, I think =LEFT(A2)="*" in w.Q2 Can't reproduce, doesn't crash for me. (In reply to David Lynch from comment #17) > Created attachment 117336 [details] > Spreadsheet exhibiting crash when altering cell fq.an1 Can't reproduce, doesn't crash for me. And please, this is not a general "this crashes" bug. It is for one specific problem.
Attachment 114042 [details] cannot be open at all from 4.4.6 (nor in master), probably a problem with some backport. Before opening a new bug, I ask if it makes sense due to this one unresolved.
Different problem, so I opened bug 95419 for that.
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
@Eike: is this fixed?
It's only workarounded.. the actual cause is yet to be determined and eliminated.
Lowering importance as the actual crash is fixed, still keeping assigned though as an "investigate again if time" reminder.
Adding Cc: to Eike Rathke
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6699afb43bffb9148960cbee2013d1704e462b9e assert a supposed-to-be-fixed condition, tdf#89957 related It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.