You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Anith Ravindran <an...@gmail.com> on 2012/02/08 21:31:12 UTC
short cut key for auto filter dropdown
Hi
I need an answer to the below conversation on your blog,
I really need to know the keyboard shortcut to display the list of
Autofilter entries in Scalc, Please help.
Descriptionvince 2007-02-03 01:02:22 UTC
Hi,
there is no way to display the list of AutoFilter entries in Calc - at
least
I
did not
find any hint towards such a functionality.
Most hardcore spreadsheet users, tend to use the keyboard only, as the
mouse
slows down the speed significantly. There should be at least some easily
accessible
option to turn this behaviour on.
Cheers
Vince
Comment 1kpalagin 2007-02-04 10:31:52 UTC
This feature would be nice to have.
vince,
any chance you could vote for the following enhancement to autofilter
http://www.openoffice.org/issues/show_bug.cgi?id=33851
Comment 2fst 2007-02-05 13:24:40 UTC
Hi Mathias,
for Validity such fields can be reached using CTRL+D. I think this should
be
possible too for Autofilter or an own shortcut for this has to be defined.
For
now it's up to you to decide with focus on the people who are used to use
keyboards only. Adjust target as needed too.
Frank
Comment 3agreppi 2008-05-12 14:16:21 UTC
CTRL+D combination only shows the list of different values the list has in
a
specific column. What is needed here (as I see the issue description) is a
function that does exactly what clicking on the little arrows in the right
bottom corner does, that is, not only showing the values, but also the All,
Top
10, Predetermined filter options, and also you should be able to select on
of
the values and make Calc show the rows in the list with that value.
That would be much appreciated.
Thanks in advance.
Comment 4mmp 2009-09-06 10:16:54 UTC
I am no longer officially active on OOo. Please take over.
Thanks
Anith
Re: short cut key for auto filter dropdown
Posted by Terry <te...@yahoo.com.au>.
Can't you create your own key binding using the menu selection Tools > Customise: tab 'keyboard'? The category seems to be 'Tables'.
----- Original Message -----
> From: Anith Ravindran <an...@gmail.com>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Thursday, 9 February 2012 7:31 AM
> Subject: short cut key for auto filter dropdown
>
> Hi
>
>
>
>
>
>
>
> I need an answer to the below conversation on your blog,
>
>
>
> I really need to know the keyboard shortcut to display the list of
> Autofilter entries in Scalc, Please help.
>
>
>
>
>
>
>
>
>
>
>
> Descriptionvince 2007-02-03 01:02:22 UTC
>
>
>
> Hi,
>
>
>
>
>
>
>
> there is no way to display the list of AutoFilter entries in Calc - at
> least
>
> I
>
>
>
> did not
>
>
>
> find any hint towards such a functionality.
>
>
>
>
>
>
>
> Most hardcore spreadsheet users, tend to use the keyboard only, as the
> mouse
>
>
>
> slows down the speed significantly. There should be at least some easily
>
>
>
> accessible
>
>
>
> option to turn this behaviour on.
>
>
>
>
>
>
>
> Cheers
>
>
>
> Vince
>
>
>
> Comment 1kpalagin 2007-02-04 10:31:52 UTC
>
>
>
> This feature would be nice to have.
>
>
>
>
>
>
>
> vince,
>
>
>
> any chance you could vote for the following enhancement to autofilter
>
>
>
> http://www.openoffice.org/issues/show_bug.cgi?id=33851
>
>
>
> Comment 2fst 2007-02-05 13:24:40 UTC
>
>
>
> Hi Mathias,
>
>
>
>
>
>
>
> for Validity such fields can be reached using CTRL+D. I think this should
> be
>
>
>
> possible too for Autofilter or an own shortcut for this has to be defined.
>
> For
>
>
>
> now it's up to you to decide with focus on the people who are used to use
>
>
>
> keyboards only. Adjust target as needed too.
>
>
>
>
>
>
>
> Frank
>
>
>
> Comment 3agreppi 2008-05-12 14:16:21 UTC
>
>
>
> CTRL+D combination only shows the list of different values the list has in
> a
>
>
>
> specific column. What is needed here (as I see the issue description) is a
>
>
>
> function that does exactly what clicking on the little arrows in the right
>
>
>
> bottom corner does, that is, not only showing the values, but also the All,
>
> Top
>
>
>
> 10, Predetermined filter options, and also you should be able to select on
>
> of
>
>
>
> the values and make Calc show the rows in the list with that value.
>
>
>
>
>
>
>
> That would be much appreciated.
>
>
>
>
>
>
>
> Thanks in advance.
>
>
>
> Comment 4mmp 2009-09-06 10:16:54 UTC
>
>
>
> I am no longer officially active on OOo. Please take over.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Thanks
>
>
>
> Anith
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org