To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=45705
Issue #:|45705
Summary:|Linking to external spreadsheets to cell names
|doesn't work
Component:|Spreadsheet
Version:|OOo 2.0 Beta
Platform:|All
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P2
Subcomponent:|editing
Assigned to:|spreadsheet
Reported by:|tuatara
--- Additional comments from [EMAIL PROTECTED] Mon Mar 21 20:21:10 -0800
2005 ---
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
=D23+D16.
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:
=G14+G7+H7.
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.
Paul
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]