https://bugs.documentfoundation.org/show_bug.cgi?id=89908
--- Comment #2 from [email protected] --- Hi Cor, now that was a quick reply! You are only partly right. Actually, what this search field does in Excel is apply a "standard filter" with the condition "Contains". I agree that your suggestion would be a way to narrow down a search but there are disadvantages: It's much slower. Instead of just writing the element you need you have to: a)click on standard filter b)click on "condition" c) select the condition d) insert the word/letters d) click "ok" Then, if you're not happy with the result you need to start again. What makes this feature in Excel so powerful is that you have a direct feedback and can adapt your search on the fly due to the autocomplete feature. Let me give another example: In a list dealing with thousands of entries related to printer models (7600, 7500, 4600, 6600, 5600) I'd like to filter for those rows related to the 7600. Among others, model references are HPI 7600 7600 Indigo 7x00/6 HP Indigo 7x00 Indigo 7600 In this case I'd quickly see that by typing 7600 I wouldn't get all the results I need, so I'd start just typing "7". This would then also give me the results for the 7500 but I'd maybe able to manually select the results I need. The bottomline is: There are lots of situations in which you either are not 100% sure about what is the best search item and you need to test it, or you do know it and want to quickly de-select those few that you don't need. In both cases I consider the "standard filter" option far too slow. Having said this, you can't image how this little feature has changed the way for me and my colleagues to manage large lists... Thanks for your feedback Marcos (In reply to Cor Nouws from comment #1) > Hi marcodtinez, Have you considered that when you click Standard filter, > that you can add any condition you need? It will be combined with settings > already done with the auto-filter. Cheers, Cor -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
