Issue 29717 - Crash caused by inserting cell
Summary: Crash caused by inserting cell
Status: CLOSED DUPLICATE of issue 4874
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-05-31 15:43 UTC by pinguino
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
xls file which causes crash when edited in a certain way. (65.50 KB, application/vnd.ms-excel)
2004-05-31 15:46 UTC, pinguino 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description pinguino 2004-05-31 15:43:59 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.
Comment 1 pinguino 2004-05-31 15:46:47 UTC 
Created attachment 15588 [details]
xls file which causes crash when edited in a certain way.
Comment 2 pinguino 2004-05-31 15:58:53 UTC 
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.
Comment 3 john.marmion 2004-05-31 17:50:51 UTC 
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.
Comment 4 frank 2004-06-01 14:28:35 UTC 
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
Comment 5 ooo 2004-06-01 15:13:15 UTC 
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 ***
Comment 6 ooo 2005-02-28 17:31:32 UTC 
Closing dupe. Fix available with issue 4874.