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: vclem...@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 <ambassa...@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@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> > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
