[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?
- Subject: [libreoffice-users] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?
- From: kuuga <Rkrskdfb@supermail77.com>
- Date: Sat, 21 Jul 2012 17:35:28 -0700 (PDT)
- To: email@example.com
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
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: firstname.lastname@example.org
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
|Re: [libreoffice-users] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?||Brian Barker <email@example.com>|
- Prev by Date: Re: [libreoffice-users] now can Purchase a NA-DVD
- Next by Date: Re: [libreoffice-users] now can Purchase a NA-DVD
- Previous by thread: [libreoffice-users] Libre Office on an iPad.
- Next by thread: Re: [libreoffice-users] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?