On Dec 27, 2011 8:42 AM, "Csanyi Pal" <[email protected]> wrote: > > Alan Boba <[email protected]> writes: > > > On Mon, Dec 26, 2011 at 11:21 AM, Csanyi Pal <[email protected]> wrote: > > > >> Alan Boba <[email protected]> writes: > >> > >> > On Mon, Dec 26, 2011 at 10:46 AM, Alan Boba <[email protected]> wrote: > >> > >> >> 2011/12/26 Csányi Pál <[email protected]> > > >> 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: [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
