Bug 98953 - [UI] Cell validation: filter possible values while typing
Summary: [UI] Cell validation: filter possible values while typing
Status: NEW
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 treegraph
 
Reported: 2016-03-29 11:44 UTC by mahfiaz
Modified: 2019-02-16 07:41 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

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 ;)