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