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 <[email protected]> To: [email protected] 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 >l > ><http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2777174.html?by-user=t> >> > >> > >> To unsubscribe from OpenOffice Spreadsheet& LibreOffice Calc, click > >> here > >> ><http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2723166&code=cG9zdHJtckBnbWFpbC5jb218MjcyMzE2NnwxNDI2MDQ1MjA0> >> > ><http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2723166&code=cG9zdHJtckBnbWFpbC5jb218MjcyMzE2NnwxNDI2MDQ1MjA0%3E&by-user=t>. >. > > > >> > > > > > > -- > > View this message in context: >http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2783708.html >l > ><http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2783708.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=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 >l > > > 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-tp2723166p2827360.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 -- 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
