Just a small variation to make it work easier for me, Shown below:
On 4/20/2016 2:19 AM, Brian Barker wrote:
At 17:05 19/04/2016 -0400, Vince Bonly wrote:
I want a drop down arrow that when clicked opens a list of
pre-written choices. This list is presently located on a separate
worksheet, titled "Lists", in AOO Calc; and it works locally there on
the List worksheet. But, I want to introduce this "drop down menu
selection" within an existing column within a separate worksheet; and
not at the head of the column.
There is no such thing as a "worksheet" in OpenOffice (Calc): each
spreadsheet (document) contains, potentially, a number of sheets.
OK; I'll try to remember to refer to them as "tabbed-sheets" (within a
local or remote spreadsheet).
I'm not sure whether you mean another sheet in the same spreadsheet or
a different spreadsheet; I'm guessing the former. Both are possible,
but neither is necessary.
o Prepare the list of prompted values.
o Select the range of cells to which this should apply.
o Go to Data | Validity... | Criteria.
o For Allow, select "Cell range".
o Either put the cursor into the Source box or click the Shrink button
to its right.
o Drag the cursor down the list of values. (This can be on another
sheet.)
Here, I hit ENTER key.
o Click the Shrink button if necessary.
o OK.
It appears that you cannot drag down a cell range on a sheet in a
separate spreadsheet document, but you *can* construct an expression
in the Source box that refers to such a cell range. (But I'm guessing
you don't want to do this anyway.)
I will want to add additional choices at a later time; ...
The simplest way to do this is probably to select a cell range (above)
that is big enough to contain as many choices as you are likely to
need. Then fill the as yet unneeded cells with copies of one of the
original values. Your list may say something like one / two / three /
four / one / one / one etc. Providing the sort option is used (see
below), only one copy of such a repeated entry will appear in the
drop-down menu.
... thus, I think the List must be on a separate worksheet so that I
can resort the entries alphabetically.
No, there are two misunderstandings here:
o It is unnecessary to sort your list of prompted values
alphabetically: you can leave it unsorted and tick the "Sort entries
ascending" box on the Criteria tab in the Validity dialogue.
Yes; now that I am using the correct dialogue window, sorting is not an
issue.
o In any case, there would be nothing to stop you sorting this list
separately if you wished - without sorting any rows or surrounding
values.
I trust this helps.
Indeed, it has!
Brian Barker
