Issue 39947 - insert names create sometimes loses names
Summary: insert names create sometimes loses names
Status: CLOSED DUPLICATE of issue 23305
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 1.1.3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-05 11:47 UTC by lwoggardner
Modified: 2005-01-17 11:09 UTC (History)
1 user (show)

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

Attachments
Spreadsheet where you can repeated lose a name def. (24.51 KB, application/vnd.sun.xml.calc)
2005-01-05 11:48 UTC, lwoggardner 		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 lwoggardner 2005-01-05 11:47:50 UTC 
I have a spreadsheet document with a number of sheets and quite a few defined names.

If I use Insert-Names-Create" to add a particular name definition the name is
defined and it can be used in formulas.

However Insert-Names-Define does not show the name in the list, neither does
Insert-Names-Insert-Insert-All result on the new name appearing in the resultant
list.

Saving the document and re-opening shows that the name is lost.

I think this might be what 20712 referred to about losing name definitions on save.

I'll attach the file and explain how to repeat as soon as I work out how to do
that...
Comment 1 lwoggardner 2005-01-05 11:48:56 UTC 
Created attachment 21090 [details]
Spreadsheet where you can repeated lose a name def.
Comment 2 lwoggardner 2005-01-05 11:53:08 UTC 
So in the attached file NameBug.sxc

On the "Setup" sheet, select cell range A16:B16
Choose Insert-Names-Create, and select Left-Column

Change cell D16 back to its correct formula "=AnnualLeaveLoss"
You will see that that name is now working.
Choose Insert-Names-Define, not that AnnualLeaveLoss is not in the list.
Save the spreadsheet,
Open the spreadsheet, cell D16 now shows #REF! because the name definition has
been lost.
Comment 3 frank 2005-01-17 11:08:47 UTC 
Hi,

could not reproduce using OOo1.1.4 this may be a double to Issue 23305 so I set
the the flags.

Frank

*** This issue has been marked as a duplicate of 23305 ***
Comment 4 frank 2005-01-17 11:09:02 UTC 
closed double