Make numberFormat even better AND Cognitive Load

Curry Kenworthy curry at pair.com
Wed Apr 26 05:31:57 EDT 2017


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




More information about the use-livecode mailing list