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
