Don't ampute numberformat

[Mike Kerner]

Well, that would be a nice thing to have in a field widget, but I run into
formatting issues with databases, as well, especially when sorting.

On Sun, Apr 23, 2017 at 12:42 PM, Roland Huettmann via use-livecode <
use-livecode at lists.runrev.com> wrote:

> I get around with numberformt, format() and own custom functions. But the
> discussion is interesting nevertheless, even when repeating.
>
> But it would be better to have consistent support throughout the IDE with
> one preferred method covering also international formatting edge cases.
>
> What I really would love to see are fields and lists (columns at least)
> where a field/column/cell has a formatting property similar to Excels cell
> formatting.
>
> It would make life much easier to simply set such property from predefined
> options. Or formats will be user-define manually or through script.
>
> 90% of overhead in formatting would be gone when entering or displaying
> data this way. And dependent on the field formatting, the engine would
> internally convert data types when addressing such field:
>
> "put 1000 into field 1" would render "$1,000.00" if the format property
> would have been set as such. And entering 1000 would format the field in
> the same way. Using such values in mathematical operations would be
> possible without the need to strip "$" and comma symbols or thousand
> seperators, the  engine would convert text to number automatically even for
> such formats.
>
> Only for the output or numbers/dates rendered as part of a text string,
> individual formatting of numbers/dates will still be needed sometimes.
>
> Roland
> _______________________________________________
> 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
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."