* Peter Kupfer OOo <[EMAIL PROTECTED]> [240605, 19:22]:
> Ennio-Sr wrote:
> >Hi all,
> >Is it possible to get a value instead of the underlying formula when
> >importing a single named-range cell from another Spreadsheet?
> >
> >Regards,
> > Ennio
> >
> >[Using OOo-1.1.4]
> >
> Try paste special and uncheck /Formula/.
>
> You could also try pasting like normal, and the going to *Edit > Links*
> and the highlighting the appropriate link and clicking break link.
>
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? I'd suppose it worked within the same spreadsheet as it
doesn't seem to be settable as a 'general' Calc configuration ...
I found a workaround that seems to work: in the ss I'm importing from I
set a cell "=named_range" (this will show the value) and give it a new range
name (say n_r2). Then, importing n_r2 into the second ss will correctly
show the desired value!
Regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
