Ennio-Sr wrote:
* Peter Kupfer OOo <[EMAIL PROTECTED]> [250605, 11:25]:
Hi Peter,
thanks for your reply, though none of the above suggestions will work ;(
OTOH, do you think that past special should work between two different
spreadsheets?
Yes it should and does. Usually I have to use the Link check box in
order to make the formula update, otherwise I just get the value, so I
am surprised it didn't work. :(
Peter,
I'm glad to say that you're perfectly right!
It does work: a very stupid error was preventing correct grasping of
values from the other ss: I was referring to 'Sheet1' whereas the name was
'A'..... ;-)
I'm now using the 'Reference to a cell in another ss' (i.e.
'file:///path/file.sxc'#Sheet_name.$Col$Row)
instead of the Insert/External data
Yeah! Glad all is well. :)
--
Peter Kupfer -- Using OOo since 'OO4 -- [EMAIL PROTECTED]
Want to help? http://www.oooauthors.org
For OOo tips: http://openoffice.peschtra.com/ooo_tips_tricks.html
To order OOo: http://openoffice.peschtra.com/distro/ooo_distro.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
