Players Loot value wrong when Qty > 1

Need Help with the Loot Divider?
Ask in this section!
Post Reply
neofax
Soldier
Soldier
Posts: 11
Joined: Wed Mar 17, 2010 1:26 pm

Players Loot value wrong when Qty > 1

Post by neofax » Sun Jun 27, 2010 10:47 am

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.

User avatar
Duniagdra
Divine Rank 21
Divine Rank 21
Posts: 6862
Joined: Sat Dec 29, 2007 5:17 pm
Location: Newark, New Jersey, USA
Contact:

Re: Players Loot value wrong when Qty > 1

Post by Duniagdra » Mon Jun 28, 2010 7:07 pm

When you moved the data, did you copy and pasts special>>formulas?
Image Marcus Tilsworth - Human Sorcerer
Image Ulyuk Bok - Elan Gestalt
Image Tryzscatzmel Ry - Gnome Alchemist
Image Image
Image

neofax
Soldier
Soldier
Posts: 11
Joined: Wed Mar 17, 2010 1:26 pm

Re: Players Loot value wrong when Qty > 1

Post by neofax » Mon Jun 28, 2010 9:34 pm

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.

User avatar
Duniagdra
Divine Rank 21
Divine Rank 21
Posts: 6862
Joined: Sat Dec 29, 2007 5:17 pm
Location: Newark, New Jersey, USA
Contact:

Re: Players Loot value wrong when Qty > 1

Post by Duniagdra » Mon Jun 28, 2010 10:07 pm

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.
Image Marcus Tilsworth - Human Sorcerer
Image Ulyuk Bok - Elan Gestalt
Image Tryzscatzmel Ry - Gnome Alchemist
Image Image
Image

User avatar
admin
-={ CREATOR }=-
-={ CREATOR }=-
Posts: 13433
Joined: Wed May 25, 2005 5:51 pm
Location: Canada
Contact:

Re: Players Loot value wrong when Qty > 1

Post by admin » Tue Aug 03, 2010 11:23 pm

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

Post Reply

Return to “Help Desk”