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

On Dec 27, 2011 8:42 AM, "Csanyi Pal" <csanyipal@gmail.com> wrote:
> 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

You're welcome. Glad I was able to help.

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