[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

--
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