Make numberFormat even better AND Cognitive Load

prothero at earthlearningsolutions.org prothero at earthlearningsolutions.org
Wed Apr 26 09:39:25 EDT 2017


Curry,
This is great and best of all is the table of examples. This, in the dictionary, would have made my thrashing around with format, to get what In wanted a lot easier.
Bill

William Prothero
http://es.earthednet.org

> On Apr 26, 2017, at 2:31 AM, Curry Kenworthy via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> 
> Roland:
> 
>> I vote for the LC-NATIVE "Excel style" number format
>> (enhanced numberFormat in LC, not a new one, no
>> depreciation, but just different ways to achieve the same)
> 
> Excel number format is powerful and popular, that's for sure.
> 
> Richard:
> 
>> The Excel spec is a guide, but not an implementation.
>> Making that work robustly, flexibly, and sensibly within
>> LiveCode is a considerable design project.
> 
> SpreadLib supports a portion of the Excel number and date formatting, a good start on that effort and with some lessons learned. Excel does have its quirks like everything else.
> 
> Over time I've also chosen my own favorite "Curry Lite" formatting features, with the convenience of a single code for both positive and negative. I tried some tests with that style, and here are the results:
> 
> http://curryk.com/ck-num-format.png
> 
> <http://curryk.com/ck-num-format.png>
> 
> I can choose where to put a negative sign or parentheses, and include arbitrary text. Maybe I can break that out into a separate formatting library. Still want to try some of the crazier things that Excel can do. :)
> 
> Best wishes,
> 
> Curry Kenworthy
> 
> _______________________________________________
> 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





More information about the use-livecode mailing list