Page 1 of 1

Syntax forgiveness? [added]

Posted: Mon May 24, 2010 11:18 am
by scarymike23
This is just a suggestion.

It would be great if the syntax was a little more forgiving. Example:

longsword [1,keen,cold iron] is correct.

however, I often (while quickly typing as my DM is rattling off loot) type something like this:
longsword [1, keen, cold iron] which won't work, as it doesn't like spaces after the commas.

also, is it possible to have it "pop up" suggestions when typing item? Like I type "Sc" and it starts showing me all the items that start with Sc below (like google search suggestions do). I recognizing this might be asking for a lot out of excel, so once again, I'm just making a suggestion.

Thanks for all your hard work, I love the loot divider!
-Mike

Re: Syntax forgiveness?

Posted: Mon May 24, 2010 11:53 am
by Duniagdra
This sounds like a lost of VBA, which the Loot Divider is meant to steer clear from so it's compatible with other spreadsheets.

Re: Syntax forgiveness?

Posted: Mon May 24, 2010 12:44 pm
by admin
scarymike23 wrote:This is just a suggestion.

It would be great if the syntax was a little more forgiving. Example:

longsword [1,keen,cold iron] is correct.

however, I often (while quickly typing as my DM is rattling off loot) type something like this:
longsword [1, keen, cold iron] which won't work, as it doesn't like spaces after the commas.
A most excellent idea!!!!
I've modified the LD to be more forgiving for leading/trailing spaces:
Ex: This won't cause any problems -> dagger [1, bane , keen , frost , flaming , holy ]
This will be available in the next update! Excellent suggestion! thank you!
scarymike23 wrote:also, is it possible to have it "pop up" suggestions when typing item? Like I type "Sc" and it starts showing me all the items that start with Sc below (like google search suggestions do). I recognizing this might be asking for a lot out of excel, so once again, I'm just making a suggestion.
I'd like that as well, but the combo boxes are under the control of Excel (I'm not sure this is even possible in VBA). As a work around, I posted this trick to get to items faster...
scarymike23 wrote:Thanks for all your hard work, I love the loot divider!
-Mike
If you really want to thank me, just let others know about it by writing a review for it on sites like paizo or dtrpg!

Thanks!!
admin

Re: Syntax forgiveness?

Posted: Mon May 24, 2010 1:47 pm
by scarymike23
admin wrote: A most excellent idea!!!!
I've modified the LD to be more forgiving for leading/trailing spaces:
Ex: This won't cause any problems -> dagger [1, bane , keen , frost , flaming , holy ]
This will be available in the next update! Excellent suggestion! thank you!
Sweet, thanks!
admin wrote: If you really want to thank me, just let others know about it by writing a review for it on sites like paizo or dtrpg!

Thanks!!
admin
I already wrote a review on Paizo, and dtrpg won't allow you to write a review without a purchase first. But I have been spreading the word among my gamer friends. :)

Thanks again,
-Mike

Re: Syntax forgiveness?

Posted: Thu Jan 31, 2013 11:05 pm
by admin
scarymike23 wrote:also, is it possible to have it "pop up" suggestions when typing item? Like I type "Sc" and it starts showing me all the items that start with Sc below (like google search suggestions do). I recognizing this might be asking for a lot out of excel, so once again, I'm just making a suggestion.
As I mentioned previously, this is actually handled by Excel itself - which it is not doing/allowing as far as I know.
BUT!
The next update of the LD will feature a Quick Pick button to help you select items faster - provided you are using the 32 bits version of Excel.
admin

Re: Syntax forgiveness?

Posted: Sun Feb 03, 2013 3:43 pm
by scarymike23
looking forward to it.

Re: Syntax forgiveness?

Posted: Sun Feb 03, 2013 3:56 pm
by admin
scarymike23 wrote:looking forward to it.
The update was posted 3 days ago...
As a Contributor, you can download it in the Contributor section!

admin