Players Loot value wrong when Qty > 1
Players Loot value wrong when Qty > 1
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.
- Duniagdra
- Divine Rank 21
- Posts: 2266
- Joined: Sat Dec 29, 2007 5:17 pm
- Location: Newark, New Jersey, USA
- Contact:
Re: Players Loot value wrong when Qty > 1
When you moved the data, did you copy and pasts special>>formulas?
Re: Players Loot value wrong when Qty > 1
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.
- Duniagdra
- Divine Rank 21
- Posts: 2266
- Joined: Sat Dec 29, 2007 5:17 pm
- Location: Newark, New Jersey, USA
- Contact:
Re: Players Loot value wrong when Qty > 1
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.
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
Ok that's a good point.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.
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