Issue 73997 - spreadsheet data range name conventions do not match input completion conventions
Summary: spreadsheet data range name conventions do not match input completion convent...
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.2
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-01-29 22:29 UTC by saturnarc
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description saturnarc 2007-01-29 22:29:02 UTC
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 
Comment 1 kpalagin 2007-02-01 18:10:13 UTC
Confirming with OO 2.1 on WinXP.
Comment 2 frank 2007-03-19 14:37:41 UTC
One for the requirements team
Comment 3 frank 2007-03-19 14:38:29 UTC
changed Plattform and OS