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 08:46:08 +0000 2008 ------- > 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! I do not quite understand this statement. In general named ranges should be preferred whenever feasible (and I strongly prefer them), because they make the sheet much more structured, and indeed the user can easily remember 3 months later what he was doing. I especially point here to some of my feature requests to extend the concept of named ranges/variables: - issue 66886 (to restrict names to a particular sheet) and - issue 67499 (which, besides other things, would allow organising these definitions and adding sensible comments to every definition) http://www.openoffice.org/issues/show_bug.cgi?id=66886 http://www.openoffice.org/issues/show_bug.cgi?id=67499 As I said, at some time point every 'string'-name will be a valid column (even this 'VeryVeryLongVariableName') and so would preclude the use of any sensible name. Also, I expect variable names to be as short as possible, therefore I strongly oppose artificial 'X_6v or' the like. They only increase error rates and mistakes. At the same time, it is unlikely that a particular user, which has defined PI2 will actually use column PI2. Still, most people use less than 100 columns. Why wasting so many resources for just the rare use of more columns. --------------------------------------------------------------------- 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]
