<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - add filter in Validity drop-down list while entering value to cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114393">114393</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>add filter in Validity drop-down list while entering value to cell
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>79045_79045@mail.ru
</td>
</tr></table>
<p>
<div>
<pre>Description:
add filter in Validity drop-down list while entering value to cell.
If I have over 100 value in cells and I use them in Validity (cell range), then
i must long scroll this long long drop-down list to find need item.
I offer add filter while entering value to cell with Validity, that make less
list of variants
Steps to Reproduce:
1. Create Validity , variant - cell range for any cell in spreadsheet
2. Use many cells with values for this cell range
3. Select your cell with Validity and open drop-down list
4. Find value needed to you. Good, if this value was in begin of list. And if
not? You must scroll long list and carefully see to values to find needed value
to you =(
Actual Results:
we have long list of values in cell with Validity and there isn't filtering for
it
Expected Results:
we can begin entering of value in the cell and we'll have short list of values
in our list
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:58.0) Gecko/20100101
Firefox/58.0</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>