Apache OpenOffice (AOO) Bugzilla – Issue 116539
"define name" causes infinite loop
Last modified: 2017-05-20 09:57:06 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
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
Please attach spreadsheet.
No info from author.