[libreoffice-users] Re: Forms in Spreadsheets

Pikov Andropov has written on 2/22/2014 4:48 PM:
> I have a spreadsheet which has two sheets -- Checkout and PaddleNumbers.
>
> Checkout has the following columns
> A: Code
> B: Item
> C: Opening Bid
> D: Paddle Num
> E: Buyer Name (contains =VLOOKUP(D2,$PaddleNumbers.A$2:B$110,2,0)
> suitable incremented)
> F: Amount
>
> while PaddleNumbers has
> A: Paddle NUM
> B: Name
>
> I would like to add a form so that a person can enter a Code, a Paddle
> Number and an Amount, and have those fields (including Buyer Name)
> populated.
>
> The tutorials I've found have been for Excel and an older OO Calc, and I
> have not been able to figure it would. Any help would be appreciated.
>
> Also, how do I protect the spreadsheet so that nothing can be changed
> except from the form?
>
> If anyone would like me to email a sample off-list, I'd be more than
> happy to do that.
>
> Thanks.


Is this visible?

-- 
To unsubscribe e-mail to: users+unsubscribe@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