Issue 124267 - Crash when insert name for range
Summary: Crash when insert name for range
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.0
Hardware: All Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: h
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-02-20 07:53 UTC by Rainer Bielefeld
Modified: 2017-05-20 09:57 UTC (History)
4 users (show)

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

Attachments
Sample Document (267.13 KB, application/vnd.sun.xml.calc)
2014-02-20 07:53 UTC, Rainer Bielefeld 		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 Rainer Bielefeld 2014-02-20 07:53:29 UTC 
Created attachment 82637 [details]
Sample Document

Steps how to reproduce with server installation of "AOO 4.1.0-Dev – English UI / German locale - [AOO410m1(Build:9750) - Rev. 1566800 - 2014-02-12]" on German WIN7 Home Premium (64bit)", own separate user profile:

1. Open attached sample document, focus sheet "Softphone"
2. Select E20:E20 (does not matter)
3. <control+f3> ('Insert -> Names -> Define') to create range with name
   > Dialog appears
4. Type name "xxx" (does not matter) -> [ok]
   Bug: AOO becomes unresponsive, has to be terminated via WIN dialog

Additional Info:
(a) was still ok with OOo 2.0.2 (If necessary I can test additional ones)
(b) No problem with LibO 4.1.3
(c) Not a general problem, until now I only observed hang with 1 particular
    document (addresses collection) from what I created the sample document
Comment 1 Andre 2014-02-20 08:33:55 UTC 
Confirmed, adding the regression keyword.
Comment 2 Andre 2014-02-20 09:28:21 UTC 
From stepping through the code it looks like the process is just very slow because the algorithm seems to look at all cells.  Some cells seem to have broken content (eg table2(Telefonanlage), B732) which additionally slows it down.

So, the bug seems to be triggered by a bad algorithm when confronted with a huge amount of data.
Comment 3 Oliver Brinzing 2014-02-20 09:31:13 UTC 
.
Comment 4 Rainer Bielefeld 2014-02-20 12:26:25 UTC 
(In reply to Andre from comment #2)
> So, the bug seems to be triggered by a bad algorithm when confronted with a
> huge amount of data.

Seems to be related to formulas, may be also damaged formulas. I replaced all formula contents characters in document by "f" (so no longer formulas in the document), afterwards hang problem has vanished, name insertions only takes a fraction of a second.
Comment 5 Oliver-Rainer Wittmann 2014-02-21 14:27:06 UTC 
I can also confirm the described defect - reproducible in AOO 4.0.1 and AOO 4.0.0, works in AOO 3.4.1
Comment 6 Andre 2014-03-07 10:00:44 UTC 
@Rainer: Per comment 4, can we close this bug as not reproducible?
Comment 7 Rainer Bielefeld 2014-03-07 13:12:20 UTC 
Closing for now. I will do some research concerning performance with (damaged ?) formulas later comparing 2.0.2 and 4.1.0 later, if I find something what should be improved I will submit a new enhancement request.