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] Fri Aug 8 17:31:18 +0000 2008 ------- The problem with the proposed approach is: 1. variable names have to be typed 2. cells can be selected with the mouse I mention this, because it is easy to mistype something like AB_6 or AB6v and still end with cell [AB6] instead of the variable name. IF the user names something PI2, or to give an example that I often use APACHE2, then I still believe that the chance of an error will be dim and the chance of a calculation with a cell PI2 (and APACHE2 - when spreadsheets will support as many columns) is rather small. But as you said, it is not zero. Instead of forbidding valid names (and highly desirable names), I would adopt an overall better solution: - Calc could detect such conflicts and mark the respective cell -- mark only IF the cell is non-empty -- it is unlikely that the user would reference an empty cell - the user is then warned that a similar name and cell do exist I still believe that the liberal use of names greatly outweighs the negative consequences. If people were using more often names, then they would start both to organise better their spreadsheet and also reduce a great number of other errors. This would by far offset the rare occurrence of the mentioned naming conflict. --------------------------------------------------------------------- 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]
