Peter Frederick wrote:
> I've been working on trying to understand how numbers and currency formats
> work.
> I've got dates working nicely now and can override default display either in
> the <body> tag:
>
> <body ex:formats="currency { decimal-digits: 2 }
> date { template: 'dd MMM yyyy'}"
> >
>
> or in tabular views or tables within tabular views.
>
> I thought I should be able to do the same thing with currency (and number)
> formats but it's eluding me!
>
> I have a schema valueType of number on my currency field because I wanted to
> use a NumericRange facet to bracket. This facet works fine. So the
> .tranamount field is being treated as a number.
>
> I have a table view defined like this:
>
> <!-- EASY TABLE View -->
> <div ex:role="exhibit-view"
> ex:viewClass="Exhibit.TabularView"
> ex:columns=".custnumber, .custname, .label, .trandate,
> .tranamount, .paiddate, .daysoutstanding"
> ex:columnLabels="Customer, Name, Inv No, Inv Date, Amount, Date
> Paid, Days"
> ex:columnFormats="list, list, list, date, currency, date {
> template: 'dd/MM/yyyy' }, number"
> ex:rowStyler="zebraStyler">
> </div>
>
> The dates work fine (ie: .trandate appears as 01 Mar 2008, .paiddate appears
> as 01/03/2008).
> The .tranamount field however is not working as expected. It does convert
> numbers like 594.0 to 594.00 but there is no $ dollar sign and numbers like
> 13720.85 appear without the thousands comma and with no $ sign. After
> searching the mailing list I've loaded in some javascript code mentioned a
> few times (the reassignment of
> Exhibit.Formatter._NumberFormatter.prototype.formatText and the addCommas
> function).
>
> Any comments on what I'm doing wrong here?
>
>
> I have also got a tabular view that is making use of a HTML table so I can
> right align the .tranamount field and justify other columns easier. It is
> defined like this:
>
> <!-- CONTROLLED TABLE View -->
> <div ex:role="view" ex:viewClass="Tabular"
> ex:formats="date { template: 'dd/MM/yyyy' } currency {
> decimal-digits: 2 }"
> ex:columns=".custnumber, .custname, .trandate, .paiddate,
> .daysoutstanding, .label, .tranamount, .ontime"
> ex:columnFormats="list, list, date, date, number, list,
> currency, list"
> ex:columnLabels="Customer, Name, Inv Date, Paid Date, Days, Inv
> No, Amount, Classification">
> <table>
> <tr>
> <td width="10%" ex:content=".custnumber"></td>
> <td width="30%" ex:content=".custname"></td>
> <td width="10%" ex:content=".trandate"></td>
> <td width="10%" ex:content=".paiddate"></td>
> <td width="7%" ex:content=".daysoutstanding"></td>
> <td width="7%" ex:content=".label"></td>
> <td width="10%" ex:content=".tranamount" align="right"></td>
> <td width="16%" ex:content=".ontime"></td>
> </tr>
> </table>
> </div>
>
> The date override format is working here but not the currency one. It
> doesn't do what I expected with the .tranamount field. ie: 594.0 appears as
> 594.0 (no two decimal place and no $ sign, and 13720.85 appears right
> justified as 13,720.85 - it's added the comma but no $ sign.
>
> Any comments to give me a better clue here?
>
> The example is inside our firewall but I'd be happy to email the html and
> it's small JSON file that shows the problem.
>
Hi Peter,
Please do email the HTML and JSON files that show the problem. It could
easily be a bug on our end. Thanks!
David
_______________________________________________
General mailing list
[email protected]
http://simile.mit.edu/mailman/listinfo/general
