re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?

Hi,


> Message du 26/12/11 16:25
> De : "Csányi Pál" 
> A : "Libre Office" 
> Copie à : 
> Objet : [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?
>
> Hi,
>
> I'm working on a spreadsheet and I want to copy/paste a function.
>
> When I copy/paste the function Calc increase some address in the 
> functions that I have in the cell and those addresses aren't proper for 
> my purpose.
>
> Eg. I want to copy/paste the value of a cell:
> =HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))
>
> but when I paste it, I get:
> =HA(DARABÜRES('1.'.AD7);"0";HA('1.'.AD7="1";"-";HA("1"<'1.'.AD7<"6";"+";"hamis")))
>
> and that isn't good for me, because I want to get
> =HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))
>
> in the new cell;
> actually I would like to get:
> =HA(DARABÜRES('2.'.AD6);"0";HA('2.'.AD6="1";"-";HA("1"<'2.'.AD6<"6";"+";"hamis")))
>
> but I think that that this can't be achieve with Calc, right?
>
> How can I copy/paste the function so so the addresses in the function 
> remain the same as in the original cell?
>
> Best Regards, Pál

Use "absolute cell reference".
Press Shift+F4 will change relative to absolute reference for the active cell.

Your formula =HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))
will change in 
=HA(DARABÜRES($'1.'.$AD$6);"0";HA($'1.'.$AD$6="1";"-";HA("1"<$'1.'.$AD$6<"6";"+";"hamis")))

$ before sheet, column or row reference fixed them. They do not increase when copied.

Gérard
-- 
For unsubscribe instructions e-mail to: users+help@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