[libreoffice-users] Re: How do I move a formula without changing it?

On 1/4/15 3:11 PM, Kaj Persson wrote:
> You might have the answer in your own question, even I am not quite
> ready in my thinking about this.
>
> If you move the formula (e.g. via the sequence ctrl+X and ctrl+V at the
> new position, well you can do it via the edit menu instead)  the
> references do not change, the formula still points at the same cells as
> in the first position. It is when you copy the formula the references
> change, as they are relative. However to really get them absolute, you
> have to anchor them with the "$" sign.

That is very cool.  I tried it and it works.  I didn't realize there was 
a difference between copying and cutting.



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted