A scroll is a spell (or collection of spells) that has been stored in written form
neofax wrote:How would I go about adding scrolls to the list? In our campaign, the GM gives out scrolls as treasure and I would like to track these and typing each one is not fun.
Mosaic wrote: It seems that a drop-down menus in Excel can only handle so many choices. This was actually a small problem before - in version 1.0 (1.1?) bonked out at "Horseshoes of Peerless Speed" and didn't make it all the way through the wondrous item list. But now it won't even scroll farther than "Divine Scroll of Silence."
Yep, I am also talking about that.Mosaic wrote:Excel 2004 for Mac, version 11.4.1
And just to make sure we're talking about the same thing, I'm talking about the long drop-down menu that appears in column B of the Treasure! tab. For me, it doesn't seem to be able to be longer than 1024 lines.
The Demo Video (in the Preview section of the Home Page) shows the Item Filter in action (at around time index 1:43) - You can check that for an example of use.Mosaic wrote:Also, you mention the All Items filter. I hadn't fiddled with that before. Now that I try, it gives me the little up/down arrows as if there were a drop down menu, but there is no drop down menu. What should I be seeing here? The treasure types list so I don't actually have to scroll through the whole list? That'd be handy.
So it does appear to be some limitation on Mac Excel. Perhaps you can google about this to see if it is a glitch in excel (that was fixed) or just a hard limit in Excel.Mosaic wrote:Interestingly enough, when I type in "divine scroll of silence" manually, the correct values pop up (so it's tapping into the data lists), and when I type in "divine scroll of snare" (next on the data list, the first that DOES NOT appear on my pull down menu), it also pops up with the correct values. So it is still referring back to the data lists correctly, it's just not displaying the full list.
Mosaic wrote:]Side question. Even if it's displaying the full list on PCs, that's a list that is well over 1000 items long. You know how on some programs you pull down a menu and some of the menu items have little arrows next to them, opening up second pull down menus that are subordinate to the items on the first pull down menu? Any chance an Excel sheet can do that? That way the first pull down menu wouldn't have to show EVERYTHING, just the main categories (potion, scroll, wand, staff, etc.). The specific wands could show up in the second subordinate pull down menu. You wouldn't have to see all the wands unless you were actually looking for a wand. It would certainly trim down that massive list considerably.
admin wrote:Did you see this Tip on how to access 'stuff' faster? That could be helpful...!
Users browsing this forum: No registered users and 1 guest