Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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 users+help@libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.