* Eike Rathke <[EMAIL PROTECTED]> [240505, 20:56]:
> Hi Ennio-Sr,
>
> On Sat, May 14, 2005 at 23:54:32 +0200, Ennio-Sr wrote:
>
> > I have a doubt about the way drag&drop operates with named ranges that
> > is hopefully explained by this example:
> > In the following Ss, A1 is a named range 'nra1'
> > ----------------------------------
> > | A B
> > ----------------------------------
> > 1 | 10 =nra1*2 (-->20)
> > 2 | 20 ???
> > 3 | 30 ???
> >
> > Drag©ing cell B1 in B2 and B3 will always yield the same result as
> > for cell B1, i.e. '20', whereas I would expect '40' and '60'.
> > This means that the named range is considered as a fixed ref ($A$1) and
> > as such is copied to the other cells.
>
> This depends on how the named range is defined. If it is defined as
> $A$1, for example, it is an absolute address that doesn't change when
> copying formulas. If the name was defined to read A1 instead it is
> adapted when the formula is copied. Note that when defining names using
> relative addresses the current cell cursor position is relevant. For
> your example you'd have to position the cursor on cell B1 before opening
> the "define name" dialog, and then specify A1 as address, resulting in
> a range "one column to the left, same row".
>
> > IIRC the behaviour was different
> > in Lotus (cannot verify at the moment); in similar circumstances, if:
> > . cell A2 was also a named range, cell B2 would become =nra2*2,
> > otherwise it would be reported as: A2*2
>
> Which would be yet something different.
>
> > Could somebody confirm this is a feature and not a bug?
>
> It is a feature and not a bug ;-)
>
> Eike
>
> --
> OOo/SO Calc core developer. Number formatter bedevilled I18N
> transpositionizer.
> GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
Thanks for your excellent explanation, Eike; in the meantime I came to
the same conclusion after a few more experiments ;).
I found out why this was happening also (see issue #49425).
Best regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
