Apache OpenOffice (AOO) Bugzilla – Issue 29717
Crash caused by inserting cell
Last modified: 2013-08-07 15:12:27 UTC
I have a xls spreadsheet which crashes openoffice.org. I will attach the xls file when I can find where to do so. It crashes when I insert a blank row, then cut and paste in another row. The cell which I think causes the problem (and is in each row) contains =OFFSET(E16; -1;0)-D16+C16 Err:527 is shown wherever this calculation occurs, before the crash is reported. The spreadsheet is arranged as a tab for each month. The problem does not occur in the earlier months, but occurs by the tabs April, May, or June. (It is not fixed where in the spreadsheet the problem starts to occur) and also in the tabs for the months until Dec. The spreadsheet was originally created in Excel, which handles it without problem, although I have been using OpenOffice to edit the file for about 2 years, using versions 641 and 1.0.0 on Win 98 and 1.0.1 and 1.1.1 on Linux (SuSE8.1 and 9.1 respectively). I found that on Windows the error was reported, but a crash did not occur, it only crashes on Linux. A crash report can be provided, if required. I will give a procedure for causing the crash, when I can attach the offending file.
Created attachment 15588 [details] xls file which causes crash when edited in a certain way.
To cause the crash pick a month tab in the latter part of the year, say sept. Put the cursor on A11 and insert a row (Alt-I, R). Select A12:F12, and copy (Ctrl-Ins). Move the cursor to A11, and insert the copied cells (Shift-Ins). For me Err:527 is now shown in all occupied cells in column E. a report is shown: "An unrecoverable error has occured..." If any more details are required, let me know.
I am able to re-create the Err:527 which indicates the Formula Interpreter has some problem with cell references but I cannot re-create the crash on Linux. I will spend some more time to see why we output the Err:527 and see if I can create the crash.
Hi Eike, as you told me, this could possibly an Issue with circular refferences. So I assign this Issue to you. Crash was not reproducible. The Issue itself only on Unix maschines. Frank
Clarification: not circular references, but recursion: cell references a cell that references a cell that references a cell that ... caused by the OFFSET() function calls, which result in obtaining a value from the previous row, continuing on the previous sheet in case of the first entry of the "Current" column. I also couldn't reproduce a crash (using a recent developer version, didn't try with OOo1.0.0 or so), but some Err527 cases might have nasty side effects under certain conditions. If you don't get a crash but only a Err527, you may get correct results when issuing a hard recalc by hitting Shift-Ctrl-F9 I set this issue duplicate to issue 4874. *** This issue has been marked as a duplicate of 4874 ***
Closing dupe. Fix available with issue 4874.