Description:
In WPS Office when you create a drop down list of items and you go to enter a new item you can type in any part of the letters in the list and it will show you the available items in the drop down list that meet those letters. Here is a an example. If I have year 2017, year 2018, year 2019 in a drop down list I can type "2018" it will give me the option to click on "year 2018" with the mouse or hit the down arrow key and then hit enter and "year 2018" will be filled in the box. Unlike ever other spreadsheet program out there where you have to type most of the beginning of the word before you are given which list item you want. This may not seem like a big feature but when you have a drop down list with hundreds or even more items to choose from being able to type in just a part of an item in the drop down list and then presented with those that match what you have typed saves a lot of time. This would be helpful when dealing with parts list or buildings and room numbers or any list where you need to find something based only looking for a few letters for example. You could type in a part number and it would list all the drop down list items with those part numbers or you could type in a room number and it would show you all the buildings that have those room numbers. If you want to see how this works install a copy of WPS office and try it out for yourself. It is a great feature and I have yet to find any other spreadsheet program out there that reproduces this. I am currently working for a company doing an inventory where the building name and room number are tied together in a drop down list so being able to just type in 400 for example (for the room number) allows me to quickly find the item because the room number is at the end of the list item description, example: College of Business (Room: 400).

Actual Results:
N/A

Expected Results:
N/A


Reproducible: Always


User Profile Reset: No



Additional Info:
N/A