Issue 116539

Summary: "define name" causes infinite loop
Product: Calc Reporter: dean <provinsd>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CLOSED IRREPRODUCIBLE QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, oliver.brinzing
Version: OOO330m18Keywords: needmoreinfo
Target Milestone: ---   
Hardware: Unknown   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description dean 2011-01-20 22:26:32 UTC 
I have a large spreadsheet (made up of 10 individual sheets) the largest of
which is 1050 rows by 243 columns.  It is the basis for all others, which happen
to be much smaller.

There are 21 names currently defined, each of which reference individual cells
and which are used for navigating around the large sheet.

When I try to add an additional name (near the bottom right hand corner) using
INSERT -> NAMES -> DEFINE, CALC goes into an infinite loop and uses 100% of the
available CPU.  I have to terminate (SIGNAL 15) and when I restart, the new name
is missing.

I define the name by typing in a legitimate name (alphanumerics and underscores,
beginning with an alpha character), ensuring the correct cell has been selected
and then "clicking" on OK
Comment 1 Oliver Brinzing 2011-01-22 10:56:09 UTC 
it is a known problem that adding/editing named ranges in large 
spreadsheets can take a long time.
try to wait some minutes - it should work
Comment 2 Edwin Sharp 2013-11-18 19:43:06 UTC 
Please attach spreadsheet.
Comment 3 Edwin Sharp 2013-12-02 20:10:14 UTC 
No info from author.