Hi all,
Mathias Röllig wrote:
Hello!
...
Imagine that you have a big table with many columns and data rows.
Now you set a autofilter in 3 or 5 columns.
Which was the first that you have set?
OK, you can remember it. But if you save the file and another person
want to work with it?
The person must reset all autofilter columns to get all data visible.
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.)
What if the filter data that is not found, is grayed instead of hiding
it completely?
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).
Sincerely,
Leonard
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" ...
And now imagine, that you want to do this with many more columns ...
It isn't a good idea always to have Excel as the only guide ...
Greetings
Mathias
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]