jQWidgets Forums

jQuery UI Widgets Forums Grid Different currencies / row

This topic contains 1 reply, has 1 voice, and was last updated by  grmbl 12 years, 6 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Different currencies / row #12452

    grmbl
    Member

    Hi,

    I need different currency symbols / row depening on row item value (currency in letters, USD, GBP, …)
    I managed to do this by using a custom cellsrenderer but it seems that I can’t get the table alignment set to right.

    Here is my code:

    // orders data
    orders = {
    datatype: "xml",
    datafields: [
    { name: 'OHPCUR', type: 'string' },
    { name: 'ITSALP', type: 'float' },
    ....
    var pricecellrenderer = function (row, column, value) {
    var dataRecord = $("#ordergrid").jqxGrid('getrowdata', row);
    var curvalue = dataRecord.OHPCUR;
    value = value.toFixed(2);
    switch (curvalue) {
    case 'EUR':
    value = '€ ' + value;
    break;
    case 'PLN':
    value = 'zł ' + value;
    break;
    case 'GBP':
    value = '£ ' + value;
    break
    default:
    };
    return value;
    };
    { text: 'Prijs', dataField: 'ITSALP', width: '100px', filtertype: 'number', cellsalign: 'right', cellsrenderer: pricecellrenderer },

    Help?

    Different currencies / row #12456

    grmbl
    Member

    Nevermind, found a fix.

    var pricecellrenderer = function (row, columnfield, value, defaulthtml, columnproperties) {
    var dataRecord = $("#ordergrid").jqxGrid('getrowdata', row);
    var curvalue = dataRecord.OHPCUR;
    value = value.toFixed(2);
    switch (curvalue) {
    case 'EUR':
    value = '€ ' + value;
    break;
    case 'PLN':
    value = 'zł ' + value;
    break;
    case 'GBP':
    value = '£ ' + value;
    break
    default:
    };
    return '<span style="margin: 4px; float: ' + columnproperties.cellsalign + '; color: #0000ff;">' + value + '</span>';
    };
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.