Peter Chabada wrote:
== Filtering lists == When you try to filter lists in Calc you don't know how many rows you get. This is useful and valuable information. I suggest show this in status bar (like MS Excel) or in tooltip. Also aggregation functions (sum, average...) below sorted selection should show values only for visible part of list (maybe with comment on affected cell). http://img213.imageshack.us/img213/2786/filtering0of.gif
To get a sum or average of only the visible cells, use the SUBTOTAL function.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
