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