Hello!
Am 12.12.2007 20:59 schrieb Leonard Mada: > 1.) I do not have a strong opinion on this. Somehow, I find > autofiltering very limited and useful only in very simple situations, > not on really big tables. (See my issue > http://www.openoffice.org/issues/show_bug.cgi?id=66588 for a better > solution. Thats why I basically have switched to MS Visual FoxPro for > such situations - not an ideal solution.) Calc isn't and shouldn't be a RDBMS. So you have find out by yourself that a database is the better solution for you. So you can switch from FoxPro to Base. I don't know if Base supports FoxPro but any other type of database. > What if the filter data that is not found, is grayed instead of hiding > it completely? It's a possibility. But I prefer to see all values. The behaviour like Excel is good for users which knows the result before filtering. All other users don't know, why there are values hidden. If there is a empty result after the n-th autofilter, then *this* is the result. This is logical, and it is more logical then values that go missing. In my opinion it must be independent if one would find "Hans" and "Meyer" in "New York" and lives in a "yellow" house or all "yellow" houses in "New York" with a lodger "Meyer", "Hans". "Simple" users don't understand why they can't select "New York" if there are many "Hans" & "Meyer" but no "Hans" *or* no "Meyer" in "New York", especially if there are many "Hans" and many "Meyer" in "New York" but no "Hans *and* "Meyer". > 2.) A big problem for autofilter are big tables, like with 50,000 rows. > The user might have 10,000 entries and it becomes very impractical to > search a value in the autofilter within this big list of entries. Some > brainstorming is needed to solve this one (I am aggressively pointing to > my previous issue). In my opinion your issue and autofilter are two different things. >> Another little example, only with 2 filter criteria. >> First you select "Hamburg" and want to get all data rows for "Lehmann". OK. >> At second you want select all "Hempel" in "Dresden". But there is no >> "Hempel" in "Hamburg" ... To make my point of view clear: Think about if there also no "Lehmann" in "Hamburg" ... This is a problem that many users have with Excel. And there is no way to reset *all* autofilter columns at once, or is there any (except to delete the autofilter)? There are many users which will not find any "Hempel" in "Dresden" if they got the sheet with active autofilter from anyone. Greetings Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·->8·-· --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
