Hi Ennio-Sr,
On Wed, Mar 09, 2005 at 21:13:37 +0100, Ennio-Sr wrote:
> I've just found out that the named ranges I defined in the table
> resulting from the Insert > External Data are useless: when I refer to
> them, even in the same sheet ("=Quote.rn_x" or "=Quote.Bx") I get "0"
> whatever value is in the referee cell.
Sounds like the ranges use relative references, and the position where
the range was created differs from the position where it is used, and
the offset applied to the data cell results in a range with an empty
cell. Be careful _where_ you define a range when using relative
references.
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]
