Page 1 of 1
Players Loot value wrong when Qty > 1
Posted: Sun Jun 27, 2010 10:47 am
by neofax
If I place a Qty of 2 Potion of Cure Moderate Wounds on the Player's Loot page, the value shows 300 instead of 600. I know I can add a second Potion of Cure Moderate Wounds, but that defeats the purpose of having qty. Also, is there a way to fix when I move the items and now the locked formulas follow the move? i.e. I select blocks cells B14-16 and drag and drop them onto B11-13 I had to close w/o saving and re-do what I did.
Re: Players Loot value wrong when Qty > 1
Posted: Mon Jun 28, 2010 7:07 pm
by Duniagdra
When you moved the data, did you copy and pasts special>>formulas?
Re: Players Loot value wrong when Qty > 1
Posted: Mon Jun 28, 2010 9:34 pm
by neofax
No, I did not. Not a big deal, as I can re-accomplish by starting over. However, I was wondering if there was a way to reset the formulas.
Re: Players Loot value wrong when Qty > 1
Posted: Mon Jun 28, 2010 10:07 pm
by Duniagdra
Perhaps I misunderstood your question. If you're asking about formulas that you cannot edit, then no, there's no way for you to do anything with that. They are protected for a reason.
If I'm still off, then please explain or maybe someone else might see what I'm missing in your post.
Re: Players Loot value wrong when Qty > 1
Posted: Tue Aug 03, 2010 11:23 pm
by admin
neofax wrote:If I place a Qty of 2 Potion of Cure Moderate Wounds on the Player's Loot page, the value shows 300 instead of 600. I know I can add a second Potion of Cure Moderate Wounds, but that defeats the purpose of having qty.
Ok that's a good point.
I've modified the Loot Divider to 'insert' a formula that will take into account changes in Quantity (and not bug out if the quantity remains empty - it will assume a quantity of one in that case). This will be available in the next update - this automation can only work on Excel's VBA - thanks!!!
admin