To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=3740
------- Additional comments from [EMAIL PROTECTED] Wed Oct 22 07:03:58 +0000
2008 -------
I have just downloaded OpenOffice 3.0.0 which I assumed would have this issue
fixed and it is certainly not fixed. OpenOffice does not work with Excel files
using named ranges referencing another file. There seems to be no difference in
its behaviour in version 3 from version 2. However named ranges within a
spreadsheet seem to be accessible. Whist checking this I also found that most
of the DDE links I use do not work though encouragingly when opening a
spreadsheet with DDE links it said that the file contained links to another file
and asked if I wanted them updated. I responded Yes but unfortunately they did
not update. However DDe links from one source did update so it could be a non
standard usage in the other program but either way it will prevent me migrating
to Open Office. The failed DDE links look like this if I have not updated links
=DDE("TRADER";"LSE\INDICES";"UKX\mid") but return the previous value and look
the same if I have updated links but return a blank, as opposed to zero ( I have
view zero switched on) .
Also although in Options I have update links set to on request at least one
spreadsheet automatically updates links to another spreadsheet resulting in name
errors so I cannot show the link format, However one spreadsheet correctly asks
if I want them updated and if I say no the link format is shown as follows:
='file:///C:/My Documents/Excel files/OPTVAL.xls'#$A.$D$9
I think what distinguishes the spreadsheet that asks about updating links form
the one that does not is the presence of DDE links in it. With spreadsheet only
links it goes straight to update. If I update links the result looks like this
Err:508
The same happens whether it is a named range or a cell reference like this.
Dou you have to convert all files to Calc files for links to work or create new
links from within OpenOffice. I tried this having saved both files in ods
format and following the help instructions using the navigator to create a link
and got a message that the link could not be updated so I will give up on
OpenOffice again.
I have been linking spreadsheets since Supercalc 30 years ago so this is
disappointing.
---------------------------------------------------------------------
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]
