To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=49425
------- Additional comments from [EMAIL PROTECTED] Wed May 18 10:41:24 -0700
2005 -------
Hi dr,
thanks for the quick reply.
I see you closed my issue as 'WORKSFORME'. AAMOF it worked for me too, so this
was not the point!
I had come to know that, as you say, <A named range cannot be absolute or
relative.> although I didn't consider this sentence as 'universal': it's
certainly true for OOo-Calc and this is exactly why I was asking whether it
would be possible (i.e. not too distructive for the present inner Calc
structure) to change that peculiarity.
In an attempt to give a deeper meening to your suggestions ("So change the
definition of your name. For example, change $Sheet1.$B$5 to B5.") I referred my
named range 'rnb5' simply to B5; however, using that name in a formula, such as
(in C5) =A5*rnb5 I get err522. Of course, I get the correct value using instead:
=A5*B5, but this is not what I wanted to achieve.
Regards,
Ennio
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
