JC Helary wrote:
Neither in Excel nor in Calc are the linked files/sheets originally
displayed. I am only translating the displayed information in the
files, I am not the creator so I don't know what was the purpose of
linking the tables in the first place.
It's a hidden sheet. You can show it with Format/Sheet/Show.
I see that if I "update the links", OOo removes all the sheet data and
only leaves what looks like an "address" in the xml. Does that mean
that when "updating" it considers that the original data is not present
on the machine and thus removes it ? That is not exactly what one could
expect from an "update" function. :)
Updating a link replaces its content with the current data from the
source file. Of course this only works if the source file is available.
Otherwise, an error message is put into the linked sheet.
I can edit the book, save it to xls and when I open it in Excel I see
that the original file is here, and just as it were before editing, the
"linked" data is not displayed.
Now, to check what is there, I re-open the xls file in OOo and check
the content.xml file. What I see is that the "addresses" are still
there and that the related data is not.
Does this mean that the person who'll use the file in the end will be
able to re-link to the contents of the original tables -if present on
his machine- or not ?
If the source file can be found at the original location, the link can
just be updated. If it's elsewhere, you can use Edit/Links to change the
link.
Are those "addresses" of any use on his side if the whole data has been
removed ?
And last but not least, what is the point of this "update the links"
function ? Is it considered that the linked data may not be useful and
thus is ok to be erased ?
It's for refreshing the values, assuming the source file is available.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
