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. 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.)
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.
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.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
