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