On 09/11/2011 03:02 PM, JeepNut wrote: > Hi all. > I want to make a spreadsheet that has a cell that has a little pulldown > list arrow on the side of the cell, so that when you click the arrow, > you see a list of things you can choose that populates the cell. > > I'm not a "strong" spreadsheet user, so when I'm looking at the help > file I'm not sure what all the references are to this form and that data > filter, etc. It's all very confusing when you don't really know what > they are referencing. > > I've been poking around using this example I have for instance of a > checkbook regsiter type of spreadsheet. > There is one page of the spreadsheet for "catagories" for instance which > is just a list of "catagories" like Food, Clothing, etc. > Then on the MAIN spreadsheet page in the cell you just click the button > and pick the catagory. > But I don't see any "formulas" that I can copy that make this happen in > the one I'm trying to build. ... I think what you are looking for is 'list'. See: http://www.libreoffice.org/get-help/documentation/ Calc Guide (full book) (ODT), (PDF) Pages 46 & 47.
-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted