[users] OOo-1.1.4-Calc: Drag&Drop named ranges

[Ennio-Sr]

[Using OOo-1.1.4 under Debian/Sarge]

Hi all,
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&copying 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. 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

Could somebody confirm this is a feature and not a bug?

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]