[libreoffice-users] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?

http://nabble.documentfoundation.org/file/n3996910/RQ6CSTemplate.ods
RQ6CSTemplate.ods 

http://i.imgur.com/ggIvJ.jpg

Hello, I am having trouble wrapping my head around some things with both
spreadsheet and database. I haven't worked with either since I graduated in
2007, so I don't really know what I'm doing.
My project is to create a fully interactive and (as much as possible)
automatic character sheet for a roleplaying game.
Right now I have a crude but functional sheet that is able to work with
everything vital except equipment variables. 

I attached a picture of what I am trying to accomplish that has me
confounded at the moment. I want to, in the weapon and armor tables, be able
to populate the whole row with relevant data simply by selecting an item in
the Name columns. For example, if I enter Broadsword in the weapon name
column I want it to automatically fills  the rest of the row with its
damage, size, reach and so on.
For the moment I've simply created drop-down lists with all the possible
variations for each field and ask the user to refer to the rulebook and
extra sheets I'm creating, as a quick reference to select the appropriate
values.

Another thing I want to do, but isn't really necessary, is make the sheet to
automatically subtract your total bonus skill points as you assign them to
skills; I simply can't figure out a way to accomplish this. I embedded my
spreadsheet file to this message if you want to dig into the details; I
welcome any advice on how to make my functions more efficient. 



--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-populate-a-whole-row-in-Spreadsheet-by-importing-from-Database-into-only-one-cell-tp3996910.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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