Description: When creating a spreadsheet, if I have a column where there are frequently repeated values, it would be handy to have the suggestion based on the most used rather than alphabetical (as you don't get multiple options anyway). For example, I do finances on a spreadsheet, and one of the columns is the location the receipt is from. Say I go to Burger King all the time, its handy when I put "B" or "Bu" to just tab to the next field and "Burger King" would come up. Now say I go to a place while on holidays (as a once off) named Burger Bites. Once this is entered, it will always be the default until I type "Burger K" as it is alphabetically first (seems to be how it works from experimenting). I think the way it calculates suggested text is most used (as you are most likely to want that) or at least a setting you can change to make it this way. Steps to Reproduce: 1. Type "Burger King" into A1, A2 and A3 2. Type "Bu" into A4, "Burger King" should be suggested, so press enter 3. Type "Burger Bites" into A5 4. Type "Bu" into A6, now in this field and any other fields this will be suggested as "Burger Bites", would be more useful to be "Burger King" Actual Results: "Burger Bites" will be suggested for this column. Expected Results: Would like it to say "Burger King" as suggested (while there are more instances of "burger King" in that column). Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36
*** This bug has been marked as a duplicate of bug 43742 ***
*** This bug has been marked as a duplicate of bug 78545 ***