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@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > 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
