TNX for the reminder to use Data-Validity-Criteria (i.e., not use
Data-Filter-Auto Filter)! I have Cut & Pasted instructions into the
tabbed-sheet for future reference.
I have incorporated my drop down choice listing in my application
spreadsheet, and all seems to be working as expected. This has made a
difference for me when entering the names of common vendors, etc.
On 4/19/2016 5:05 PM, Vince wrote:
AOO412m3(Build:9782) - Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
Win 8x64
____________________________________
I have done this once before, but am not able to repeat it.
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.
I have tried Data-Filter-Auto Filter, but that seems to require
beginning at the very top of a column.
I will want to add additional choices at a later time; thus, I think
the List must be on a separate worksheet so that I can resort the
entries alphabetically.
Thanks for reading this.
Regards,
Vince B.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org