Apache OpenOffice (AOO) Bugzilla – Issue 73997
spreadsheet data range name conventions do not match input completion conventions
Last modified: 2013-08-07 15:12:27 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 conventions.
Confirming with OO 2.1 on WinXP.
One for the requirements team
changed Plattform and OS