To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92153
------- Additional comments from [EMAIL PROTECTED] Thu Aug 7 02:59:09 +0000
2008 -------
Quote discoleo:
RULE:
=====
Named 'ranges/expressions/...' shall have precedence over column identifiers.
RATIONALE
=========
If a 'range/expression/whatever' has been named, THEN the user most definitely
wants to use this name in subsequent expressions, so it is more likely that he
indeed wants this name and NOT the column ID.
***This seems logical, but... A user might forget (3 months later) that she has
defined VARIABLE AB6, refer to CELL AB6, and get (without warning) a wrong
result using variable AB6 --not what she meant!
So, variable names that can be interpreted as a cell names or ranges should
be forbidden. That should upset no user --not even one allergic to restrictions;
variable AB6 can be renamed AB_6, or AB6v ('v' for variable),or AB6_, or
whatever form that cannot be construed as cell name.
If OO3 encounters (in a file written by an earlier version) forbidden
variable names, it could either flag them or convert them --eg, by appending an
illegal char (like #) or a 'v' to each --provided that does not duplicate an
existing name: if AB6v already exists, AB6 could be renamed AB6w, or AB6_, or...
---------------------------------------------------------------------
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]
