[libreoffice-users] Re: Help w Spreadsheet function?

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+help@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