To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=38839
User malvineous changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|WORKSFORME |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sat Jan 22 18:15:58 -0800
2005 -------
Hi,
I think you might've misinterpretted my explanation - it does work if you type
'=' and then click on a cell in another file (and this is the way I was hoping
it would work) however if you've made inter-sheet references in one file, and
then import one of those sheets into another file, all the references change to
#REF instead of the original document's filename - but sometimes they also
change to apparently random sheet names instead.
It does however seem that once you've typed '=' and clicked in the other file
suddenly it all starts working the way it should. Except that I seem to have
stumbled across another bug, in that if the reference is to Doc1#Sheet2 after
the import it changes to Doc1#Sheet1. I think the following steps should
reliably reproduce these problems:
1. Close all instances of OOo
2. Open Calc with a new spreadsheet
3. In Sheet1, cell A1, type "=Sheet2.C5"
4. Go to Sheet2 and in cell C5 type "1234"
5. Go back to Sheet1 and cell A1 should now contain the value 1234.
6. Save the document as one.sxc
7. Create a new spreadsheet.
8. Close one.sxc. You should now have only one OOo window open, a blank
spreadsheet.
9. From the Insert menu, choose "Sheet..."
10. Select "From File" and Browse to select one.sxc
11. Select "Sheet1" in the list, make sure the "Link" checkbox is ticked, and
click OK.
12. You will now see a new sheet called "Sheet1_2" and in cell A1 it contains
the formula "=Sheet1.C5" which is incorrect - not only should it really be
Sheet2 as you entered in the original file, but it should be
"='file:///..../one.sxc'#Sheet2.C5" to maintain the linked reference (which is
why you select Link in the first place when inserting the sheet.)
Hopefully these instructions will allow you to reproduce the problem.
---------------------------------------------------------------------
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]
