Issue 109948 - Inability to import data from a named cell in another sheet
Summary: Inability to import data from a named cell in another sheet
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1.1
Hardware: PC All
: P5 (lowest) Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-08 16:57 UTC by dmhurrell
Modified: 2014-02-07 12:49 UTC (History)
2 users (show)

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

Attachments
spreadsheet 1 (13.50 KB, application/vnd.ms-excel)
2014-02-07 12:46 UTC, Edwin Sharp 		no flags Details
spreadsheet 2 (13.50 KB, application/vnd.ms-excel)
2014-02-07 12:47 UTC, Edwin Sharp 		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 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