Hi Mathias,
Mathias Röllig schrieb:
Hello!
Am 07.12.2007 10:42 schrieb Thomas Benisch:
1.3 Change to AutoFilter popup list
Let me annotate something to the wanted change of the autofilter
behavior so it would work like in excel.
http://specs.openoffice.org/calc/ease-of-use/AutoFilter_Behavior.odt
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 a other person
want to work with it?
The person must reset all autofilter columns to get all data visible.
The down arrow of an AutoFilter drop down becomes blue if a filter
criteria is set on that column. So the user can go to these blue drop
downs to withdraw a single filter or un-check Data-Filter-AutoFilter to
turn off the entire AutoFilter. The order of the single filters is
irrelevant for the result.
A other 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
Best regards,
Frank
--
Sun Microsystems GmbH Frank Loehmann
Nagelsweg 55 User Experience StarOffice
20097 Hamburg Phone: (+49 40)23646 882
Germany Fax: (+49 40)23646 550
http://www.sun.de mailto:[EMAIL PROTECTED]
Sitz der Gesellschaft: Sun Microsystems GmbH,Sonnenallee 1,
D-85551 Kirchheim-Heimstetten, Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schröder, Wolfgang Engels,Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
