Re: [libreoffice-users] difficulty with spreadsheet links

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 <stuckybyler2@yahoo.es>
> To: users@libreoffice.org
> 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 users+help@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
>
>
>       
> -- 
> Unsubscribe instructions: E-mail to users+help@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***