[Libreoffice-bugs] [Bug 124900] New: Drop down list search feature.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124900

            Bug ID: 124900
           Summary: Drop down list search feature.
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dawnofwar1970 at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190423/180f494c/attachment.html>