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

Alan Boba <aboba0@gmail.com> writes:

> On Mon, Dec 26, 2011 at 11:21 AM, Csanyi Pal <csanyipal@gmail.com> wrote:
>
> > Alan Boba <aboba0@gmail.com> writes:
> >
> > > On Mon, Dec 26, 2011 at 10:46 AM, Alan Boba <aboba0@gmail.com> wrote:
> >
> > > > 2011/12/26 Csányi Pál <csanyipal@gmail.com>

> > It works for the next raw, but how can I use this behavior when I want to
> > copy to a different column?
> >
> > When I'm trying to copy to the next column:
> >
> > =HA(DARABÜRES('5.'.$AD6);"0";HA('5.'.$AD6="1";"-";HA("1"<'5.'.$AD6<"6";"+";"hamis")))
> >
> > It remains like this:
> >
> > =HA(DARABÜRES('5.'.$AD6);"0";HA('5.'.$AD6="1";"-";HA("1"<'5.'.$AD6<"6";"+";"hamis")))
> >
> > and the address $AD6 doesn't changed to $AD7, why?
>
> I'm a bit lost by your question. Copying the first formula to another cell
> _on_the_same_row_ should have exactly the result you've shown.

My question abowe is about that that if one want to copy a formula into
a cell say one raw lower, then addresses in formula would change without
'$' prefix but wouldn't change (again, without '$' prefix) if the same
formula want to copy into a cell that is in the same raw. I hope I'm
clear now. (Sorry for my English.)

> If the cell reference in the formula should change from $AD6 to $AD7 then
> after copying the formula it must be pasted one row below the row it is
> copied from. If the formula is in cell A1 and copied from there to cell B2
> the cell reference in the formula will be updated from $AD6 to $AD7. Note
> the destination I've given is on a different row and in a different column.
> However only the row number would change because the column value is
> preceded by "$". If the formula is pasted into a cell two rows lower then
> the cell reference would change from $AD6 to $AD8 and so on.

All right, I understand You perfectly. Thanks for the explanation!

-- 
Regards, Pal


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