Erik Remmelzwaal-2 wrote: > > 2009/1/4 windyweather <[email protected]> > > Did you try the Freeze option with Calc? Set focus to e.g. cell D2 and > choose from menu Window->Freeze. Now the the row 1 and columns A, B and C > will not scroll. > > This kind of administration does me remind about the time that I played > text > based adventure games on the Commodore 64. Looks like the games did not > make > much progress since then (in respect to manual administration)... > > Success, > > Erik > >
Thanks, I'll look into the freeze option. Sounds like just what I needed. Turns out that in just a few min I was able to build a base application that works. It's even pretty smart, in a DB kind of way. I'm not very practiced as a DB admin, but I have three tables, Chars, Armor, Weapons and have made a query that joins Chars/Armors on a common ID so that the DB is some kind of Normal Form. Gee it seems to work. Then I built a report that groups the armor records, sorted by level under the Character Name title. What I Can't do at this point is edit the records in Armor or weapons with a form. I'm not sure if OOBase understands the idea of a Join in a form. I'll experiment some more with that later. So if I keep the form open under the game at least I'll know what pieces that I need to pick up for my characters while farming. At some point I'll probably post a blog entry with the base file as an attachment so that other folks can help enhance it. Thanks for the quick response on the Freeze thing. I'll try that sometime, but I think the Base solution makes more sense for this application. They sort of cripple you intentionally in 2Moons. Stashes - out of character storage - is back at the castle and it is Per-Character rather than Per Account, like it is with Guild Wars. Per Account storage means that at least when you get back to town you can figure out who has what easily because it's all there. But with 2Moons you have to remember, or switch chars and check, and then "mail" the armor and weapons between characters so they can stash it. That's what causes the requirement for the db. I never needed that in Guild Wars due to the account wide storage. These games are all about the math, the book keeping and the loot anyway.... ;) That's never going to change. I'm not plugging 2Moons or Acclaim, but 2Moons is completely free to download and use. So if you want to see where things are now, there is only a modest time investment... They have an interesting business model that is probably what is coming for the gaming industry in general... But that's another topic and another forum... - cheers windy -- View this message in context: http://www.nabble.com/OO-Spreadsheet-or-Base-problem---tp21280691p21281853.html Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
