Trying a custom handler for several math fields

Vaughn Clement vclement at gmail.com
Sat Sep 14 12:55:02 EDT 2013


Hi Richard

Frankly I was surprised that LC did not recognize commas and money symbols.
This is a standard thing in almost any software that has numbers being
used? I would think it could be added to the object inspector to set the
money settings, and maybe still treat the field as a string for purposes of
calculations.

Thank you

Vaughn Clement

Apps by Vaughn Clement (Support)
*http://www.appsbyvaughnclement.com/tools/home-page/*
Skype: vaughn.clement
https://secure.join.me/appsbyvclement
FaceTime: vclement at gmail.com
LogMeIn also avaialble
Call on "ooVoo" at address:  vaughnclement or 9282549062
Ph. 928-254-9062
Cloud Hosting Registration Web Site:
https://my.oditech.com/cart.php?a=add&pid=41


On Sat, Sep 14, 2013 at 9:43 AM, Richard Gaskin
<ambassador at fourthworld.com>wrote:

> dunbarx wrote:
>
> > If you simply enter "$50" in an excel cell and then add that cell
> > plus "3" to another cell, it works fine. No explicit currency
> > formatting needed. I think you said this. Excel has this knowledge
> > built-in, Try it with "#50". But that only means that Excel
> > understands the "$" sign, helping the user with a shortcut.
> >
> >
> > LiveCode does not, because it simply sees three characters in that
> > "$50" string and takes it at face value.
>
> I think the key here is that Excel separates the stored value from its
> display representation, while doing this in LC requires some scripting.
>
> It would be ideal if we could have a displayFormat property for fields and
> chunks, so that we could set it to something like "$0.00" and then putting
> "2.4" into the field would cause the field to render as "$2.40".  Likewise
> we would want to be able to set the displayFormat for columns in
> multi-column list fields.
>
> Until such time as the engine may ever have such a feature (useful as it
> would be, I've never seen it on a roadmap), we can get a similar outcome
> with a well-crafted behavior script.
>
> A really good script would take some effort to produce, but would be very
> useful to the community.  If someone's in a position to start such a
> project I'd happily contribute to it.
>
> --
>  Richard Gaskin
>  Fourth World
>  LiveCode training and consulting: http://www.fourthworld.com
>  Webzine for LiveCode developers: http://www.LiveCodeJournal.com
>  Follow me on Twitter:  http://twitter.com/**FourthWorldSys<http://twitter.com/FourthWorldSys>
>
>
>
> ______________________________**_________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode>
>



More information about the use-livecode mailing list