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 15:13:26 +0000 2008 ------- Quote discoleo: I do not quite understand this statement. In general named ranges should be preferred... I agree, and I use them. But, suppose you defined variable AB6 for some formula, 3 months ago. Now, you reopen the same spreadsheet to add some some other calculation using cells AB6 and AB7, say '=AB6+AB7'. (Even if you 'strongly prefer' named ranges, you likely use also direct cell references, for their simplicity.) IF you are very careful, you will first hit ^f3 to check if AB6 or AB7 has already been defined as a variable. However, the average user will not even think of doing such a check, and believe he has added cells AB6 and AB7, when in fact he has added VARIABLE AB6 to cell AB7, without error message since the operation is legal --but not what was intended! 'Friendly' software should --within reason-- protect the 'careless' user against likely mistakes. (Toughware will tell the user: 'Haha! You should have known that AB6 is a variable name!') Forbidding variable names that would duplicate cell names is an simple way to avoid the above problem, and this restriction is very easy to satisfy: if the name 'AB6' is not a legal variable name, 'AB_6' is, as are 'AB6v', 'AB6_', .... --------------------------------------------------------------------- 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]