Reply inline > On Feb 11, 2016, at 3:35 PM, Vince <wa.two...@verizon.net> wrote: > > > TNX Jim for the info; I will give it a try, but would like to be clear about > how to compose the required reference string and about where to properly > locate the drop-down selection list . You can locate it anywhere you find convenient. I’d suggest that you put it on another sheet, but you don’t have to.
> I will first try with the selection list definition being located on a sheet > within the same workbook. I could name that sheet "Selection Lists" and > write a reference string to that. I would pick a short name. If you put a space in the title, it has to be quoted when you reference it. Just call it “Lists,” or something like that. If you’ll use the shrink button as I said, you don’t have to “write” any references. It’s all done for you. You just select the range of the cells in which the choices appear. But you can write it if you want to: $Lists.$A$1:$A$5 will work just as well as selecting with the shrink button, and it works just as well. All those $’s hold the reference in one spot. They’re called “Absolute references.” > I have not ever tried to write a reference string to a sheet that is located > within a separate Workbook file, and do not know if that is possible to work. Well, you *can* put the list in a separate workbook, but both workbooks have to be open for the reference to work. Just keep it in the same workbook, but on a different sheet. Sheets are selected with the tabs at the bottom of the window where it says “Sheet1”, “Sheet2”, and “Sheet3.” You can add more sheets if you need them, and you can change the names. Right-click on the sheet tab to bring up a context menu that will allow you to change the sheet name. ***If you’re going to do that, though, do it before you create your reference list. > > At this point, my selection list must include the following that I plan to do > logic operations on from another sheet: > > * With Vets '16 > * With George '16 > * During '16 BVL Practice > * During '16 BVL Competition > * '16 Practice Alone List them just the way I told you: One selection per cell, all cells in the same column. > > Those choices are associated with a Workbook where I record my bowling scores > and George's bowling scores, such as they are! In some cases I bowl a 3-game > series whereas in other cases I bowl a 5-game match, and yet when practicing > alone, any number of games may be bowled!. This isn’t rocket science, and nowhere near as hard as picking up a 7-10 split. Just give it a try and throw a few gutter balls. We learn best from failure. Good thing programming doesn’t hurt, or I’d be a wreck. > > Regards, > VinceB. > > > > On 2/11/2016 12:18 PM, James Plante wrote: >> First, create the choices that you want to have in the dropdown list: In a >> blank spreadsheet, >> Go to cell D1. Enter “One”, return; in D2 enter “Two”, return; etc. Let’s >> say you do six entries, D1:D6. >> >> Now, select the cell at which you want to make the dropdown list. Let’s use >> A2. Now go to >> Data->Validity; you’ll get a dialog box. In that box, at the “Allow” prompt, >> click the dropdown box and select “Cell Range.” The dialog changes. >> >> On the right of the “cell range” box, select the “shrink” button. Now in the >> spreadsheet, select D1 and drag to D6. Hit the shrink button again, and once >> again the dialog changes. The selected range of inputs is now >> $Sheet1.$D$1:$D$6. >> >> Click “OK” and you’re good to go. Cell A2 now has an arrow next to it when >> it is selected—and only when selected! Click the arrow, and you can choose >> any of the six entries you made in D1:D6. >> >> There are other options available in the dialog. Explore them. You can use >> numbers, text, or formulas that give rise to arrays. Read the docs to find >> out more about it. (Google is your buddy.) >> >> For instance, if you had a bunch of different cells in which you wanted to >> control or expedite data entry, you could put all the selections in >> different areas on Sheet2. Then when it’s time to select your cell range, >> shrink the dialog, change sheets, select the desired range, hit shrink >> again, and the dialog would show something like “$Sheet2.$F$10:$F$15”, and >> those choices would populate your target cell. >> >> Jim Plante >> >>> On Feb 11, 2016, at 10:56 AM, Vince <wa.two...@verizon.net> wrote: >>> >>> Hello: >>> >>> Using AOO 4.1.2 on WIN 8.1. >>> >>> I do not know the correct terminology for searching in HELP file, but I >>> want to have a drop down selection list, with a clickable arrowhead, inside >>> a Calc cell. How can this be done? >>> >>> Regards, >>> VinceB. >>> >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
