OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Auto expand dropdown list

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
rww
General User
General User


Joined: 05 Aug 2010
Posts: 45

PostPosted: Sat May 05, 2012 4:23 am    Post subject: Auto expand dropdown list Reply with quote

I have a cell with a dropdown list. I would like to have the list expand when tabbed to so that the arrow keys could be used to scroll down the list and the enter key could be used to select from the list rather than having to use the mouse to click the dropdown arrow and then clicking on the selection. I haven't yet found anything on the forum explaining how to do this.

Thanks
Back to top
View user's profile Send private message AIM Address
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat May 05, 2012 4:33 am    Post subject: Reply with quote

OOo version (or LibreOffice)?
Combo box form control?
List box form control?
Cell validation drop down?
Cell auto-content drop down?
Tried Ctrl+D or Alt+DownArrow?
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
rww
General User
General User


Joined: 05 Aug 2010
Posts: 45

PostPosted: Sat May 05, 2012 9:22 am    Post subject: Reply with quote

Sorry.

OOo 3.1.0
Control is a defined range.
Validation is cell range (not sure this is what you're looking for)
Not sure here, either.
Ctrl+D works to expand the list, Alt+Downarrow doesn't

Even though Ctrl+D works, I'd like the list to auto expand when tabbed to, if possible.

Thanks.
Back to top
View user's profile Send private message AIM Address
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat May 05, 2012 11:28 am    Post subject: Reply with quote

Like 90% of all questions in this spreadsheet forum this could be solved easily in a database (input form with tall list box in this case).
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group