Hi Tom, Yes I had the OO as copy/paste between sheets and that is all I had to do to get them updating correctly. When I tried same with say from a OO sheet to a new LO sheet then the LO sheet would not update whenever the OO sheet changed so I had to go back to all the OO sheets and "convert" them to LO. However even then the LO sheet/s would not update correctly...
Now there are several instances in LO re Updating linked Cells: In Options-General I have Update Links When Opening set to Always In the Sheet I have Tools-Cell Contents set to Autocalculate In the Help doc (under Updates, links on opening) it also says one can use Edit-Links... This also mentions DDE links and using Copy/Paste Special and setting the Link option. I am not sure about this as it mentions it is relative to text data and losing decimals etc. and if you use this on a cell you get a linked address to the cell it is linked from which has different address (extra DDE info) than if you just use Copy/Paste. Hope that is all clear! I think the Help doc could use some clarification. rrand On 16/04/11 17:04, Tom Davies [via Document Foundation Mail Archive] wrote: > Hi :) > > Did you set one of them (OOo or LO) to use links like Excel? I'm not > sure where > to look that up > Regards from > Tom :) > > > > > ________________________________ > From: rrand <[hidden email] > </user/SendEmail.jtp?type=node&node=2827373&i=0&by-user=t>> > To: [hidden email] > </user/SendEmail.jtp?type=node&node=2827373&i=1&by-user=t> > Sent: Sat, 16 April, 2011 7:51:26 > Subject: [libreoffice-users] Re: OpenOffice Spreadsheet & LibreOffice > Calc > > Hi Frank, > > Thanks but I am using Ubuntu Linux. I found that when converting > OpenOffice sheets to LibreOffice that there is a problem with linked > cells and one has to save the LibreOffice sheet to a new name (cannot > re-use existing ods file). > > On 15/04/11 16:23, Frank Godbersen [via Document Foundation Mail > Archive] wrote: > > > hi rrand, > > try to deactivate the "pre-start-option" (?) - with me (unter Win 7 and > > XP) it works. > > regards > > Frank > > Am 06.04.2011 06:42, schrieb rrand: > > > > > I am having problems with LibreOffice which will not link cells > > > correctly from one sheet to another, whether they were originally > > > created in OpenOffice or not. > > > > > > On 05/04/11 07:49, Ryan Jendoubi [via Document Foundation Mail > Archive] > > > wrote: > > >> Hello rrand, > > >> > > >> On 24/03/11 00:27, rrand wrote: > > >>> There is a difference in the way these two handle linked cells. If > > >> you have > > >>> a cell linked to another spreadsheet in OpenOffice then if you open > > >> it in > > >>> LibreOffice the value is not automatically updated if it > > changes/or has > > >>> changed in the spreadsheet it is linked to. LibreOffice seems to > > only > > >>> 'remember' the old value even if you relink the cell. > > >>> > > >>> This could pose problems when one wishes to no longer use > > OpenOffice in > > >>> favour of LibreOffice as you do not know if any linked values are > > being > > >>> updated properly. > > >> > > >> I've not experienced your problem directly, but I know that in > Writer > > >> the default settings for updating linked Fields are sometimes not > > >> intuitive. > > >> > > >> Maybe there's a preference you can set somewhere about automatic vs > > >> manual updating of links? > > >> > > >> Bests, > > >> > > >> -r > > >> > > >> -- > > >> Unsubscribe instructions: E-mail to [hidden email] > > >> </user/SendEmail.jtp?type=node&node=2777174&i=0&by-user=t> > > >> Posting guidelines + more: > > http://wiki.documentfoundation.org/Netiquette > > >> List archive: http://listarchives.libreoffice.org/www/users/ > > >> All messages sent to this list will be publicly archived and > cannot be > > >> deleted > > >> > > >> > > >> > > >> > > > ------------------------------------------------------------------------ > > >> If you reply to this email, your message will be added to the > > >> discussion below: > > >> > >http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2777174.html > > > <http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2777174.html?by-user=t> > >l > > > ><http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2777174.html?by-user=t> > > > <http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2777174.html?by-user=t%3E&by-user=t> > >> > > >> > > >> To unsubscribe from OpenOffice Spreadsheet& LibreOffice Calc, click > > >> here > > >> > >< > > > >< > >. > > > > > > >> > > > > > > > > > -- > > > View this message in context: > >http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2783708.html > > > <http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2783708.html?by-user=t> > >l > > > ><http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2783708.html?by-user=t> > > > <http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2783708.html?by-user=t%3E&by-user=t> > >> > > > Sent from the Users mailing list archive at Nabble.com. > > > > > > > > -- > > Unsubscribe instructions: E-mail to [hidden email] > > </user/SendEmail.jtp?type=node&node=2823542&i=0&by-user=t> > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/www/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > > > > ------------------------------------------------------------------------ > > If you reply to this email, your message will be added to the > > discussion below: > >http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2823542.html > > > <http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2823542.html?by-user=t> > >l > > > > > > To unsubscribe from OpenOffice Spreadsheet & LibreOffice Calc, click > > here > >< > >. > > > > > > > -- > View this message in context: > http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2827360.html > > <http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2827360.html?by-user=t> > > Sent from the Users mailing list archive at Nabble.com. > -- > Unsubscribe instructions: E-mail to [hidden email] > </user/SendEmail.jtp?type=node&node=2827373&i=2&by-user=t> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- > Unsubscribe instructions: E-mail to [hidden email] > </user/SendEmail.jtp?type=node&node=2827373&i=3&by-user=t> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > > ------------------------------------------------------------------------ > If you reply to this email, your message will be added to the > discussion below: > http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2827373.html > > > To unsubscribe from OpenOffice Spreadsheet & LibreOffice Calc, click > here > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2723166&code=cG9zdHJtckBnbWFpbC5jb218MjcyMzE2NnwxNDI2MDQ1MjA0>. > > -- View this message in context: http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2827396.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
