Bug 98953 - [UI] Cell validation: filter possible values while typing
Summary: [UI] Cell validation: filter possible values while typing
Status: RESOLVED DUPLICATE of bug 94513
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Validity
  Show dependency tree / graph
 
Reported: 2016-03-29 11:44 UTC by mahfiaz
Modified: 2023-04-04 11:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot of Google Sheets (147.46 KB, image/png)
2016-03-29 15:20 UTC, mahfiaz 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description mahfiaz 2016-03-29 11:44:22 UTC 
When data validation with list of options is enabled for a cell, it shows the usual drop-down.

To get there select a cell, from menu open Data → Validation, select e.g "List" as the "Enabled" option and fill in a few lines below as options.

Now the cell should have a nice drop-down of options. In Google Sheets once you start typing in such a cell, it opens the dropdown and filters all the results and shows only matching ones.

I find this to be much easier to use, especially with lot of different options.
Comment 1 Cor Nouws 2016-03-29 13:13:22 UTC 
Thanks for filing Mahfiaz. Set to new.
Comment 2 mahfiaz 2016-03-29 15:20:44 UTC 
Created attachment 123924 [details]
Screenshot of Google Sheets
Comment 3 mahfiaz 2016-09-20 06:55:19 UTC 
Also worth noting that for performance reasons Google Sheets does case insensitive filtering matching only the START of string. So "ab" would match abacus but not labrador.
Comment 4 Cor Nouws 2016-09-20 07:49:02 UTC 
(In reply to mahfiaz from comment #3)
> Also worth noting that for performance reasons Google Sheets does case
> ...

I doubt that performance is the reason. Cannot imagine there are many validation lists that produce huge amount of data ;)
Comment 5 Stéphane Guillou (stragu) 2023-04-04 11:40:29 UTC 

*** This bug has been marked as a duplicate of bug 94513 ***