Issue 109948

Summary: Inability to import data from a named cell in another sheet
Product: Calc Reporter: dmhurrell <dhurrell>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P5 (lowest) CC: elish, issues
Version: OOo 3.1.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
spreadsheet 1
none
spreadsheet 2 none

Description dmhurrell 2010-03-08 16:57:48 UTC 
importing data from named external cell

In Excel it is possible to name data in an external cell and then use
'Insert-Name-Paste' and then select the name and the data from that cell is
automatically imported into that cell.

This not seem to be possible in Calc. Indeed when importing an excel sheet or
converting an excel sheet to ods it comes up with different errors!

Using references such as C3 is messed up if a row or column is inserted so the
naming of a cell is an important way to reduce spreadsheet errors.

It seems to me essential that this problem is remedied.
Comment 1 Edwin Sharp 2014-01-11 18:24:31 UTC 
Please attach example.
Comment 2 Edwin Sharp 2014-01-26 07:21:34 UTC 
No info from author.
Comment 3 Edwin Sharp 2014-02-07 12:43:54 UTC 
Info from author by email
Comment 4 Edwin Sharp 2014-02-07 12:46:43 UTC 
Created attachment 82525 [details]
spreadsheet 1
Comment 5 Edwin Sharp 2014-02-07 12:47:11 UTC 
Created attachment 82526 [details]
spreadsheet 2
Comment 6 Edwin Sharp 2014-02-07 12:49:54 UTC 
Err:508 in cell A1 of attachment 82526 [details]
AOO410m1(Build:9750)  -  Rev. 1562493
Rev.1562493
Win 7
OK with Excel 2010