To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73997 Issue #|73997 Summary|spreadsheet data range name conventions do not match i |nput completion conventions Component|Spreadsheet Version|OOo 2.2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P5 Subcomponent|ui Assigned to|spreadsheet Reported by|saturnarc
------- Additional comments from [EMAIL PROTECTED] Mon Jan 29 14:29:02 -0800 2007 ------- In the spreadsheet app, suppose one defines a data range which is named "Cost_Bonus" and another range named "Bonus_Cost". When entering formulas into cells and typing one of these names in, the program will offer a suggestion, but does not take the underscores into account. Thus, I type "=vlookup( A1 ; Bonus" into the cell, the program offers Bonus_Cost as the completion of input, but if I enter "=vlookup( A1 ; Bonus_Cost" the program offers Cost_Bonus as the completion, and puts it after Bonus_, so it completes the input as "=vlookup( A1 ; Bonus_Cost_Bonus". It would be preferable for the data range naming conventions to match the input completion conventions. --------------------------------------------------------------------- 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]
