I have problems with links also but found it doesn't matter if the linked file
is still there. What I
am seeing is only the first link is being saved. The problem I have is I use a
third sheet to link
to a calculated value in the second file but since the linked data from the
first file is lost once
you close file 2 the data for file 3 is wrong. See post "Calc Links not all
saving".
The only way I found to fix this was to install OpenOffice 3.3. If
anyone has another
solution I would be happy to test it otherwise we will have to upgrade our
systems to
Openoffice instead of Libreoffice.
I filed a bug at
https://bugs.freedesktop.org/show_bug.cgi?id=34637
I will also file one at the wiki link mentioned as soon as I can. I
have 3 sample
spreadsheet files that show this if anyone wants to look at them.
Thanks, Ron Gregor
On 2 Mar 2011 at 12:45, Tom Davies wrote:
> Ahah, i thought you were going to say something like that. It does seem
> completely reasonable. It could lead to file sizes being larger but does
> have
> advantages.
>
>
> Is it possible to zip the file with the data-source so that both files get
> sent
> as a single attachment? or even to send both files (as 2 attachments)
> without
> zipping them? I can think of a few reasons why it might not be a workable
> work-around but if it is then that is probably the fastest temporary way to
> get
> the result you need.
>
> Can you report this as a bug-report to get a result in the longer-term?
> http://wiki.documentfoundation.org/BugReport
>
> Regards from
> Tom :)
>
>
>
> ________________________________
> From: Carola y Pablo <[email protected]>
> To: [email protected]
> Sent: Wed, 2 March, 2011 10:54:47
> Subject: Re: [libreoffice-users] difficulty with spreadsheet links
>
> The thing is, in MS Excel and Open Office, once the link is established,
> if you open up the file and don't update the links, the values remain.
> In Libre Office they disappear. This is a problem if you want to share
> the spreadsheet file with someone else who doesn't have the date file on
> their computer. Do I make myself understood?
>
> Paul
>
>
> El mar, 01-03-2011 a las 20:39 -0800, Andy Brown escribió:
> > Carola y Pablo wrote:
> > > When I link a cell in one spreadsheet to another, then close both files,
> > > if the second spreadsheet is deleted or moved, then when I open the
> > > first spreasheet, I lose the linked data.... What to do?
> > >
> > > Paul
> > >
> > >
> >
> > I do not understand here. You link to something then delete it and
> > expect to still connect to it? It is a _link_ it is not a copy of the data.
> >
> >
> >
>
>
>
> --
> Unsubscribe instructions: E-mail to [email protected]
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
>
>
>
> --
> Unsubscribe instructions: E-mail to [email protected]
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
>
--
Unsubscribe instructions: E-mail to [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
