[Solved] Key shortcut to open drop-down list

Discuss the spreadsheet application

[Solved] Key shortcut to open drop-down list

Postby wrrr » Fri Oct 01, 2010 1:17 pm

Hello,

the question will be short.

The problem.

I open new sheet, select A1 and then add some drop-down list by going through Data>Validate settings.
After selecting A1 the drop-down list open button appears on the right and I can click it and select a predefined value that would be then transfered to A1.

The question.

How do you open that list and select the value __using keyboard only__?

Is it even possible to do that? I can't find that information in the help system nor in google.

The list (combobox) should be as usable as an ordinary combobox, that is - fully operable using both mouse and keyboard, otherwise it's just as usable as putting any data in the sheet using the combination of mouse and onscreen keyboard.

Cheers,
Darius/Poland
Last edited by wrrr on Sat Oct 02, 2010 1:02 pm, edited 3 times in total.
OpenOffice 3.2.0 OOO320m12 (build 9483) on LinuxMint 9 (Ubuntu 10.04) i386
wrrr
 
Posts: 9
Joined: Fri Sep 24, 2010 9:26 pm

Re: Key shortcut to open and select value from drop-down lis

Postby MrProgrammer » Sat Oct 02, 2010 4:06 am

The answer will be short, too. Try Command+D (Macintosh) or Ctrl+D (other platforms).
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.6.8.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 1743
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Key shortcut to open and select value from drop-down lis

Postby wrrr » Sat Oct 02, 2010 11:57 am

MrProgrammer wrote:The answer will be short, too. Try Command+D (Macintosh) or Ctrl+D (other platforms).


Hm, it doesn't seem to work .

BUT, I found the reason why. The shortcut to open a dropdown list isn't assigned to any key.
I did as such:

1. Go to menu->Tools->Customize
2. Choose Keyboard tab.
3. In the Function section choose on the left: Edit, and in the middle: List*
4. Then in Key shortcut section above choose like Ctrl+Shift+D
5. Click Modify button on the right and then OK
*) I use OOo with Polish interface so I'm not sure how it's called, it could be List, Dropdown list, Listbox, correct me if I'm wrong.

Voila. I can now toss the mouse away when using dropdown lists!
yupii :bravo: :bravo: :bravo: :bravo: :bravo:
OpenOffice 3.2.0 OOO320m12 (build 9483) on LinuxMint 9 (Ubuntu 10.04) i386
wrrr
 
Posts: 9
Joined: Fri Sep 24, 2010 9:26 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests