Issue 45705 - Linking to external spreadsheets to cell names doesn't work
Summary: Linking to external spreadsheets to cell names doesn't work
Status: CLOSED DUPLICATE of issue 3740
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0 Beta
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2005-03-22 04:21 UTC by tuatara
Modified: 2005-09-07 02:27 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description tuatara 2005-03-22 04:21:10 UTC
OOo version 1.9.79

I have two spreadsheets. 
Sheet A has two cells that are named, each of which calculated from two other cells.
(as an aside: the names are current_total, new_total).
Sheet B is blank.
From Sheet B I do the following:
- Select Cell (say) C12.
- Insert | Link to external data
- Select Sheet A. 
- [At this point 'current_total' and 'new_total' are shown.]
- Select 'current_total'
- Click OK

The field formula is set to: =C9+C2 which is then evaluated locally to 0.
The field formatting seems to be copied from Sheet A!current_total

I do it again on cell D26, this time I got the formula 
Again, formatting was copied. 

I changed SheetA!current_total to be calculated from three other cells, 
such as: =H15+H8+I8
and then link to SheetB, the sheetB cell becomes: 

So: it looks like the formula is being copied rather than the value, and then
moved relative, then evaluated locally. The formatting is also copied.

I have scanned for this bug in your database. A similar one exists where
external data links are wrong, but it was 'closed' with a comment of
'WORKSFORME' from the developer. That bug had little detail so I am hoping that
the extended detail in this report will help.

All the best with it.
Comment 1 andreschnabel 2005-03-27 11:50:23 UTC

tuatara: can you give the issue number of the issue that has been closed as

Note: I've not been able to link to a named cell an a external spreadsheet at
all, so this should not be closed as "WONTFIX"
Comment 2 tuatara 2005-04-04 00:56:41 UTC
Per your question: I can't find the "WORKSFORME" bug. Darn.

Sorry about that - but I hope you are able to reproduce this one
from my description.

Comment 3 tuatara 2005-04-07 03:20:37 UTC
I think I found the other issue that was marked "WORKSFORME".
Its 44432.
Comment 4 frank 2005-04-07 11:27:29 UTC

Issue 44432 has nothing in common with this one.

This Issue is a double to Issue 3740 .


*** This issue has been marked as a duplicate of 3740 ***
Comment 5 frank 2005-04-07 11:27:44 UTC
closed double
Comment 6 gunamoi 2005-09-07 02:27:35 UTC
Please see my comments against issues 3740 and 44292, I believe this is an
important issue that needs fixing in version 2.0, and should not be left as some
'future enhancement'.