Page 1 of 1

PRoblem with player's loot

Posted: Wed Dec 10, 2014 11:17 am
by copojax
Good afternoon,
I just purchased Loot Divider for our pathfinder group, and I was trying some features before explaining to the other players.
I have excel 2013, I enter an item in "treasure!" but I found no way in having it in the player's loot WITH it's value.
I can assign it in the treasure tab or not, but in the player loot tab if I give it to a player no value appare. What am I doing wrong?
Thanks
Jacopo

Re: PRoblem with player's loot

Posted: Wed Dec 10, 2014 11:46 am
by admin
I created a +1 longsword in the treasure sheet then selected it to "Bob" on the Player's Loot... (see image)
The value appears in the players loot. When you do something similar, the value is not shown?
admin
Playerloot.jpg

Re: PRoblem with player's loot

Posted: Wed Dec 10, 2014 12:39 pm
by copojax
I did the same as you did, the longsword is shown in the drop down list in Bob's player loot, but no numbers in the value column. and the total loot assigned shows $ -

Re: PRoblem with player's loot

Posted: Wed Dec 10, 2014 3:37 pm
by admin
copojax wrote:I did the same as you did, the longsword is shown in the drop down list in Bob's player loot, but no numbers in the value column. and the total loot assigned shows $ -
Can you zip your copy of the Loot Divider (the one that does shows this issue), and email it to me at: admin@TheOnlySheet.com ?
I can't recreate this problem, which makes it difficult to see what is happening... (I need to ascertain if this problem is in Excel or in the LD you have)
Thanks!!

admin

Re: PRoblem with player's loot

Posted: Wed Dec 10, 2014 4:17 pm
by copojax
sent, thank you!

Re: PRoblem with player's loot

Posted: Wed Dec 10, 2014 6:54 pm
by admin
I was able to reproduce the behavior you describe if I add "longsword [+1]"
in the Player's Loot sheet *before* that same entry exists in the Treasure
sheet...!

Is it possible that this is what is occurring here?

When I open your 'bob' version, the 'longsword [+1]' entry has indeed no
value: If I then re-select the 'longsword [+1]' on the Player's Loot, the
value appears as expected. The value in the Player's loot is taken from the Treasure sheet ... *if* it exists.

Can you try to re-select the "longsword [+1]" on the Player's Loot page (assuming that entry already exists in Treasure)

admin

Re: PRoblem with player's loot

Posted: Sat Feb 18, 2017 11:49 pm
by sroyer98
Hello,

Has a solution been found to this problem? The same thing is happening here.

I use Loot Divider 1.80 (By the way, how can we get the latest version?)

I have Excel 2016 and I passed the macros test. I tried on a different computer with the same result.

Also, a smaller bug I see is on the Treasure! sheet. The total amount at the top should read "241gp" but instead reads ",24,.0gp". The Gold per player shows ",12gp" instead of 120gp.

Thanks for your help!

Re: PRoblem with player's loot

Posted: Sun Feb 19, 2017 12:49 am
by admin
sroyer98 wrote: Also, a smaller bug I see is on the Treasure! sheet. The total amount at the top should read "241gp" but instead reads ",24,.0gp". The Gold per player shows ",12gp" instead of 120gp.
Thanks for your help!
hmm sounds to me that this is related to Regional settings. The Loot Divider was created with the English (United States) setting in mind: May I ask which regional Settings are you using?

admin

Re: PRoblem with player's loot

Posted: Sun Feb 19, 2017 7:11 pm
by sroyer98
Which WINDOWS regional settings? Fran├žais (Canada)

If there are regional settings in Excel, you will have to tell me how to check it.

And what about the bigger problem with the Player's Loot sheet?

Thanks for your help!

Re: PRoblem with player's loot

Posted: Sun Feb 19, 2017 7:57 pm
by admin
Yes, the regional settings in Windows. Seems to me that this is the problem here.
As for the original issue, I already replied to it. Try to set the regional setting to English US, then retry the problem: Is it still there? (I strongly suspect all these issues are all related to Regional Settings...!)

Let me know!

admin

Re: PRoblem with player's loot

Posted: Sun Feb 19, 2017 11:45 pm
by sroyer98
Works!

Thank you very much!