On Sat, 2005-04-16 at 17:06 -0600, Doug Thompson wrote: > Leslye Olsen wrote: > >> > >>>Hello. Thanks in advance for any help you may offer. > >>> > >>>My issue: I would like to create a drop down menu in a cell in a > >>>spreadsheet, with a list of names or numbers as a "database". In MS > >>>Excel, I can link a range of cells in another spreadsheet, and the > >>>dropdown menu points to it. > >>> > >>>I am using OpenOffice 1.1.1 on SuSE 9.1 Personal, from the live CD > >>>install. (i386 machine...) > >>> > >>>I hope that this question is understandable and someone has some > >>>answers. Thanks again... > >>> > >>>Ruel Olsen > > I think what you are referring to is the Data Validity function in Excel > and now in OOo 2.0. It doesn't exist in any 1.x version of OOo. >
In 1.1.x, see Help > Contents > Index > Search term > validity; checking. Granted data validation in 2.0 should be better and closer to that of Excel. -- PLEASE KEEP MESSAGES ON THE LIST. Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
