Jump to content

Recommended Posts

Working with LibreOffice Calc, I wanted a pick list (listbox) outside of the macro environment.  Looking throughout the forum, I couldn't find an example of a LISTBOX that I could double-click on to make a pick from the list.

For what it's worth, this example program uses CLIPBOARD data to fill the LISTBOX then will accept your "pick" (double-click or ENTER).  In Calc, I select a column, copy it then run this program.  Pick List!

Hope it's of some use to the Forum.

Clip2List w-DblClk.au3

Link to post
Share on other sites

Yep! That's the idea.  I've got Calc columns with 1000 + entries.  To test, I copy the entire column and send that.  So far no problems.

In my particular application, I've altered the output to SEND keys back to Calc.  Ctrl-Shift-t moves the Calc cursor to the name box.  Then I construct a valid cell address and send that with a final {ENTER}.  My choice then becomes the active cell.

I tried to post a simple and straight forward script so others could understand, take it apart, alter it, hammer it into something useful.  As it is, it will accept any number of text entries from the clipboard that end in a CRLF but the clipboard isn't necessary.

Hope you enjoy.

"-Lock your wigs, inflate your shoes" 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...