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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
