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