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: [email protected]
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
