Issue 116539 - "define name" causes infinite loop
Summary: "define name" causes infinite loop
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO330m18
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2011-01-20 22:26 UTC by dean
Modified: 2017-05-20 09:57 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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.