[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 10:46 AM, Alan Boba <aboba0@gmail.com> wrote:

> > 2011/12/26 Csányi Pál <csanyipal@gmail.com>

> constant column when formula is copied $B6. A formula containing this
> reference will always us "B" as the column but the row will change if the
> formula is copied to a different row.

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?

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