Announcement

**mabboud** · 20 Jul 2018, 06:15

here is a trimmed down html of the exact same issue

Code:

<html>
<head>
<link rel="stylesheet" type="text/css" href="rollstock.css">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<SCRIPT>window.isc_useSimpleNames = false; var isomorphicDir='../isomorphic/';</SCRIPT>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Core.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Foundation.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Containers.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Grids.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Forms.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_DataBinding.js"></script>
<SCRIPT SRC="../isomorphic/skins/Enterprise/load_skin.js"></script>
</head>
<body>

<script> 
isc.SimpleType.create({
    name: 'Roll.initialWeight.bigWeight',
    inheritsFrom: "float",
    normalDisplayFormatter: function (value) {
        // Converting Pounds to Tons
        return isc.NumberUtil.format(value / 2000.0,",0.000");
    },
    shortDisplayFormatter: function (value) { 
        return this.normalDisplayFormatter(value);
    },
    getGroupTitle: function (value, record, field, fieldName, component){
        return this.normalDisplayFormatter(value);
    }
});
isc.SimpleType.create({
    name: 'RollstockOrderItem.tonsPerRoll.weight',
    inheritsFrom: "float",
    normalDisplayFormatter: function (value) {
        var v = isc.NumberUtil.format(value,",0.000");
        return v;
    },
    shortDisplayFormatter: function (value) { 
        return this.normalDisplayFormatter(value);
    },
    getGroupTitle: function (value, record, field, fieldName, component){
        return this.normalDisplayFormatter(value);
    }
});
isc.SimpleType.create({
    name: 'RollstockOrderItem.width.lineal',
    inheritsFrom: "float",
    normalDisplayFormatter: function (value) {
        // Display in Inces and Decimal Sixteenths
        var v = Math.floor(value) + Math.round((value - Math.floor(value))*16)/100.0;
        v = isc.NumberUtil.format(v,",0.00");
        return v;
    },
    shortDisplayFormatter: function (value) { 
        return this.normalDisplayFormatter(value);
    },
    getGroupTitle: function (value, record, field, fieldName, component){
        return this.normalDisplayFormatter(value);
    }
});



isc.RestDataSource.create({
    ID: 'openRollstockOrders',
    dataURL: 'rollstockOrder',
    fields:[
        { name: "rollstockOrderKey",hidden:true },
        { name: "orderNumber",title: ('orderNumber')},
        { name: "rollstockOrderItemKey", primaryKey:true, hidden:true},
        { name: "paperCode", title: ('paperCode'),foreignKey: "paper.paperCode" , allowEmptyValue:false,required: true,type:"select", displayField:"paperCode"},
        { name: "width", title: ('width'), type: 'RollstockOrderItem.width.lineal', required: true, allowEmptyValue:false},
        { name: "numberRollsOrdered", title: ('numRolls'), type: 'float',format:',0',required: true  },
        { name: 'tonsPerRoll', title: ('tonsOrdered'), type: 'RollstockOrderItem.tonsPerRoll.weight' },
        { name: "supplierOrderNumber",title: ('supplierOrderNumber')},
        { name: "dueDate",title: ('dueDate'),type:"date", useTextField:true,required: true},
        { name: 'lineNumber', title: ('lineNumber'), type: 'integer' },
        { name: 'price', title: ('price'), type: 'float' ,decimalPad: 4},
        { name: "itemDateOrdered",title: ('itemDateOrdered'),type:"date", useTextField:true},
        { name: 'rollsReceived', title: ('rollsReceived'), type: 'float',format:',0'  },
        { name: 'weightReceived', title: ('weightReceived'), type: 'Roll.initialWeight.bigWeight' },
        { name: 'rollsRemaining', title: ('rollsRemaining'), type: 'float',format:',0'  },
        { name: 'weightRemaining', title: ('weightRemaining'), type: 'Roll.initialWeight.bigWeight'},
        { name: 'intransitCount', title: ('intransitCount'), type: 'float',format:',0'  },
        { name: "printed",title: ('printed'), type:'boolean'}
    ]
});

function refreshTable(){
    invTable.invalidateCache();
    invTable.fetchData();
}

isc.DynamicForm.create({
    ID: "exportForm",
    width:300,
    fields: [
        { name: "exportType", title: "Export Type", type:"select", width:"*",
            defaultToFirstOption: true,
            valueMap: { 
                "csv" : "CSV" , 
                "xml" : "XML", 
                "json" : "JSON",
                "xls" : "XLS (Excel97)",
                "ooxml" : "OOXML (Excel2007)"
            }
        },
        { name: "showInWindow", title: "Show in Window", type: "boolean", align:"left" }
    ]
});

isc.Button.create({
   ID: "exportButton",
   title: "Export",
   autoDraw:false,
   click: function () {
       var exportAs = exportForm.getField("exportType").getValue();
       var showInWindow = exportForm.getField("showInWindow").getValue();
       if (exportAs == "json") {
           // JSON exports are server-side only, so use the OperationBinding on the DataSource
           invTable.exportData({ operationId: "customJSONExport", 
               exportDisplay: showInWindow ? "window" : "download"});
       } else {
           // exportAs is not JSON, so we can set that with requestProperties
           invTable.exportClientData({ exportAs: exportAs,
               exportDisplay: showInWindow ? "window" : "download"
           });
       }
   }
});

isc.ListGrid.create({
    ID: 'invTable',
    width: '100%',
    height: '100%',
    dataSource: 'openRollstockOrders',
    autoDraw:false
});

isc.ImgButton.create({
    ID:"refreshButton",
    title:('refresh'),
    autoDraw:false,
    src:"general_refresh.png", size:16,
    showFocused:false, showRollOver:false, showDown:false,
    click :function(){
        refreshTable();
    }

});


isc.SectionStack.create({
    ID: "sectionStack",
    visibilityMode: 'multiple',
    width: '100%',
    height: '100%',
    autoDraw:true,
    sections: [
        {     title: ('openOrders'),controls:[refreshButton,exportButton],
            autoShow: true,
            canCollapse: false,
            items: [exportForm,invTable ]
        }
    ]
})

refreshTable();

</script>
</body>
</html>

**mabboud** · 20 Jul 2018, 09:31

i have managed to develop a test case with some sample data

Code:

<html>
<head> 
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<SCRIPT>window.isc_useSimpleNames = false; var isomorphicDir='../isomorphic/';</SCRIPT>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Core.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Foundation.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Containers.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Grids.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Forms.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_DataBinding.js"></script>
<SCRIPT SRC="../isomorphic/skins/Enterprise/load_skin.js"></script>
</head>
<body>

<script> 
isc.SimpleType.create({
    name: 'Roll.initialWeight.bigWeight',
    inheritsFrom: "float",
    normalDisplayFormatter: function (value) {
        // Converting Pounds to Tons
        return isc.NumberUtil.format(value / 2000.0,",0.000");
    },
    shortDisplayFormatter: function (value) { 
        return this.normalDisplayFormatter(value);
    },
    getGroupTitle: function (value, record, field, fieldName, component){
        return this.normalDisplayFormatter(value);
    }
});
isc.SimpleType.create({
    name: 'RollstockOrderItem.tonsPerRoll.weight',
    inheritsFrom: "float",
    normalDisplayFormatter: function (value) {
        var v = isc.NumberUtil.format(value,",0.000");
        return v;
    },
    shortDisplayFormatter: function (value) { 
        return this.normalDisplayFormatter(value);
    },
    getGroupTitle: function (value, record, field, fieldName, component){
        return this.normalDisplayFormatter(value);
    }
});
isc.SimpleType.create({
    name: 'RollstockOrderItem.width.lineal',
    inheritsFrom: "float",
    normalDisplayFormatter: function (value) {
        // Display in Inces and Decimal Sixteenths
        var v = Math.floor(value) + Math.round((value - Math.floor(value))*16)/100.0;
        v = isc.NumberUtil.format(v,",0.00");
        return v;
    },
    shortDisplayFormatter: function (value) { 
        return this.normalDisplayFormatter(value);
    },
    getGroupTitle: function (value, record, field, fieldName, component){
        return this.normalDisplayFormatter(value);
    }
});

var testData = 
[
    {
        orderNumber:"ALS1512",
        paperCode:"23M",
        width:112.857,
        numberRollsOrdered:10,
        tonsPerRoll:51.48,
        supplierOrderNumber:"ALS1512-1",
        dueDate:new Date(1461124800000),
        lineNumber:1,
        price:20.5300,
        itemDateOrdered:new Date(1458238525000),
        rollsReceived:2,
        weightReceived:10331,
        rollsRemaining:10,
        weightRemaining:104530,
        intransitCount:0,
        printed:"true"
    },
    {
        orderNumber:"ALS1512",
        paperCode:"69K",
        width:132.00,
        numberRollsOrdered:10,
        tonsPerRoll:51.48,
        supplierOrderNumber:"ALS1512-1",
        dueDate:new Date(1461124800000),
        lineNumber:1,
        price:20.5300,
        itemDateOrdered:new Date(1458238525000),
        rollsReceived:0,
        weightReceived:0,
        rollsRemaining:10,
        weightRemaining:102960,
        intransitCount:0,
        printed:"true"
    }
];

isc.RestDataSource.create({
    ID: 'openRollstockOrders',
    testData:testData,
    clientOnly: true,
    fields:[
        { name: "rollstockOrderKey",hidden:true },
        { name: "orderNumber",title: ('orderNumber')},
        { name: "rollstockOrderItemKey", primaryKey:true, hidden:true},
        { name: "paperCode", title: ('paperCode'),foreignKey: "paper.paperCode" , allowEmptyValue:false,required: true,type:"select", displayField:"paperCode"},
        { name: "width", title: ('width'), type: 'RollstockOrderItem.width.lineal', required: true, allowEmptyValue:false},
        { name: "numberRollsOrdered", title: ('numRolls'), type: 'float',format:',0',required: true  },
        { name: 'tonsPerRoll', title: ('tonsOrdered'), type: 'RollstockOrderItem.tonsPerRoll.weight' },
        { name: "supplierOrderNumber",title: ('supplierOrderNumber')},
        { name: "dueDate",title: ('dueDate'),type:"date", useTextField:true,required: true},
        { name: 'lineNumber', title: ('lineNumber'), type: 'integer' },
        { name: 'price', title: ('price'), type: 'float' ,decimalPad: 4},
        { name: "itemDateOrdered",title: ('itemDateOrdered'),type:"date", useTextField:true},
        { name: 'rollsReceived', title: ('rollsReceived'), type: 'float',format:',0'  },
        { name: 'weightReceived', title: ('weightReceived'), type: 'Roll.initialWeight.bigWeight' },
        { name: 'rollsRemaining', title: ('rollsRemaining'), type: 'float',format:',0'  },
        { name: 'weightRemaining', title: ('weightRemaining'), type: 'Roll.initialWeight.bigWeight'},
        { name: 'intransitCount', title: ('intransitCount'), type: 'float',format:',0'  },
        { name: "printed",title: ('printed'), type:'boolean'}
    ]
});

function refreshTable(){
    invTable.invalidateCache();
    invTable.fetchData();
}

isc.DynamicForm.create({
    ID: "exportForm",
    width:300,
    fields: [
        { name: "exportType", title: "Export Type", type:"select", width:"*",
            defaultToFirstOption: true,
            valueMap: { 
                "csv" : "CSV" , 
                "xml" : "XML", 
                "json" : "JSON",
                "xls" : "XLS (Excel97)",
                "ooxml" : "OOXML (Excel2007)"
            }
        },
        { name: "showInWindow", title: "Show in Window", type: "boolean", align:"left" }
    ]
});

isc.Button.create({
   ID: "exportButton",
   title: "Export",
   autoDraw:false,
   click: function () {
       var exportAs = exportForm.getField("exportType").getValue();
       var showInWindow = exportForm.getField("showInWindow").getValue();
       if (exportAs == "json") {
           // JSON exports are server-side only, so use the OperationBinding on the DataSource
           invTable.exportData({ operationId: "customJSONExport", 
               exportDisplay: showInWindow ? "window" : "download"});
       } else {
           // exportAs is not JSON, so we can set that with requestProperties
           invTable.exportClientData({ exportAs: exportAs,
               exportDisplay: showInWindow ? "window" : "download"
           });
       }
   }
});

isc.ListGrid.create({
    ID: 'invTable',
    width: '100%',
    height: '100%',
    dataSource: 'openRollstockOrders',
    autoDraw:false
});

isc.ImgButton.create({
    ID:"refreshButton",
    title:('refresh'),
    autoDraw:false,
    src:"general_refresh.png", size:16,
    showFocused:false, showRollOver:false, showDown:false,
    click :function(){
        refreshTable();
    }

});


isc.SectionStack.create({
    ID: "sectionStack",
    visibilityMode: 'multiple',
    width: '100%',
    height: '100%',
    autoDraw:true,
    sections: [
        {     title: ('openOrders'),controls:[refreshButton,exportButton],
            autoShow: true,
            canCollapse: false,
            items: [exportForm,invTable ]
        }
    ]
})

refreshTable();

</script>
</body>
</html>

**mabboud** · 23 Jul 2018, 14:18

any updates on this issue ?

**Isomorphic** · 25 Jul 2018, 04:03

Thank you for the report and test case. We'll follow up here when this is fixed.

**Isomorphic** · 27 Jul 2018, 03:55

There's no bug here. Formatter you are using is not supposed to change field value. Please consider using formula field to change field value and a format like shown below.

Code:

{ name: 'weightReceived2', userFormula: { formulaVars: {A: "weightReceived"}, text: "A / 2000.0"}, format: ",0.000"}

Let us know please how this worked for you.

**mabboud** · 27 Jul 2018, 05:03

i would like to maintain using the SimpleType formatting since my databases values have different unit than user Display unit ... which can be configured on a user by user bases and doing it your way will limit how i can customize my display unit ... with the SimpleType am actually traversing through the type to look up the Database unit and Display unit which will give me what i wanted ... its not always static like the way you have it and will have a lot of duplicate code and really hard to maintain ... this Test case only an example that the export Excel is not reflecting what we are seeing on the ListGrid ... CSV and XML do show correctly

my Datasource type will define what is the Unit that will be displayed and in what format.
this is an actual example of my SimpleType:

Code:

isc.SimpleType.create({
       name: ds.fields[i].type,
       inheritsFrom: "float",
       normalDisplayFormatter: function (value) {
              return avista.formattedFieldConvert(value, table, field, measure);
       },
       shortDisplayFormatter: function (value) { 
              return this.normalDisplayFormatter(value);
       },
       getGroupTitle: function (value, record, field, fieldName, component){
              return this.normalDisplayFormatter(value);
       },
       editorType: "UOMItem"
});

this code will call the formattedFieldConvert function

Code:

this.formattedFieldConvert = function(value, table, field, measure)
    {
        var dbUOM = avista.getDatabaseUOM(table, field, measure);
        var dpUOM = avista.getDisplayUOM(table, field, measure);
        var dpFormat = avista.getDisplayFormat(table, field, measure);
        var cvrValue = avista.unitConvert(value, dbUOM, dpUOM);
        return isc.NumberUtil.format(cvrValue,dpFormat);
    }

which then it gets converted and formatted to the desired Display unit which is configured in the database that gets preloaded at the start of the application

**mabboud** · 27 Jul 2018, 05:17

i have another test case that it works with the SimpleType export to Excel but i cant tell why this one works and my first test case doesnt

Code:


<html>
<head>
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<SCRIPT>window.isc_useSimpleNames = false; var isomorphicDir='../isomorphic/';</SCRIPT>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Core.js">
</script><SCRIPT SRC="../isomorphic/system/modules/ISC_Foundation.js">
</script><SCRIPT SRC="../isomorphic/system/modules/ISC_Containers.js">
</script><SCRIPT SRC="../isomorphic/system/modules/ISC_Grids.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_Forms.js"></script>
<SCRIPT SRC="../isomorphic/skins/Enterprise/load_skin.js"></script>
<SCRIPT SRC="../isomorphic/system/modules/ISC_DataBinding.js"></script>
</head>
<body>
<script>

isc.SimpleType.create({
    name: "msfUOM",
    inheritsFrom: "float",
    normalDisplayFormatter: function (value) {
        var v = isc.NumberUtil.format(value/0.092903/1000.0,",0.00");
        return v;
    },
    shortDisplayFormatter: function (value) { 
        return this.normalDisplayFormatter(value);
    }
});

countryData = [
{
    continent:"North America",
    countryName:"United States",
    countryCode:"US",
    area:9631420,
    population:298444215,
    gdp:12360.0,
    independence:new Date(1776,6,4),
    government:"federal republic",
    government_desc:2,
    capital:"Washington, DC",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/United_states"
},
{
    continent:"Asia",
    countryName:"China",
    countryCode:"CH",
    area:9596960,
    population:1313973713,
    gdp:8859.0,
    government:"Communist state",
    government_desc:0,
    capital:"Beijing",
    member_g8:false,
    article:"http://en.wikipedia.org/wiki/China"
},
{
    continent:"Asia",
    countryName:"Japan",
    countryCode:"JA",
    area:377835,
    population:127463611,
    gdp:4018.0,
    government:"constitutional monarchy with parliamentary government",
    government_desc:1,
    capital:"Tokyo",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/Japan"
},
{
    continent:"Asia",
    countryName:"India",
    countryCode:"IN",
    area:3287590,
    population:1095351995,
    gdp:3611.0,
    independence:new Date(1947,7,15),
    government:"federal republic",
    government_desc:2,
    capital:"New Delhi",
    member_g8:false,
    article:"http://en.wikipedia.org/wiki/India"
},
{
    continent:"Europe",
    countryName:"Germany",
    countryCode:"GM",
    area:357021,
    population:82422299,
    gdp:2504.0,
    independence:new Date(1871,0,18),
    government:"federal republic",
    government_desc:2,
    capital:"Berlin",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/Germany"
},
{
    continent:"Europe",
    countryName:"United Kingdom",
    countryCode:"UK",
    area:244820,
    population:60609153,
    gdp:1830.0,
    independence:new Date(1801,0,1), 
    government:"constitutional monarchy",
    government_desc:1,
    capital:"London",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/United_kingdom"
},
{
    continent:"Europe",
    countryName:"France",
    countryCode:"FR",
    area:547030,
    population:60876136,
    gdp:1816.0,
    government:"republic",
    government_desc:5,
    capital:"Paris",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/France"
},
{
    continent:"Europe",
    countryName:"Italy",
    countryCode:"IT",
    area:301230,
    population:58133509,
    gdp:1698.0,
    independence:new Date(1861,2,17),
    government:"republic",
    government_desc:5,
    capital:"Rome",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/Italy"
},
{
    continent:"Asia",
    countryName:"Russia",
    countryCode:"RS",
    area:17075200,
    population:142893540,
    gdp:1589.0,
    independence:new Date(1991,7,24),
    government:"federation",
    government_desc:3,
    capital:"Moscow",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/Russia"
},
{
    continent:"South America",
    countryName:"Brazil",
    countryCode:"BR",
    area:8511965,
    population:188078227,
    gdp:1556.0,
    independence:new Date(1822,8,7),
    government:"federative republic",
    government_desc:3,
    capital:"Brasilia",
    member_g8:false,
    article:"http://en.wikipedia.org/wiki/Brazil"
},
{
    continent:"North America",
    countryName:"Canada",
    countryCode:"CA",
    area:9984670,
    population:33098932,
    gdp:1114.0,
    independence:new Date(1867,6,1),
    government:"constitutional monarchy with parliamentary democracy and federation",
    government_desc:1,
    capital:"Ottawa",
    member_g8:true,
    article:"http://en.wikipedia.org/wiki/Canada"
},
{
    continent:"North America",
    countryName:"Mexico",
    countryCode:"MX",
    area:1972550,
    population:107449525,
    gdp:1067.0,
    independence:new Date(1810,8,16),
    government:"federal republic",
    government_desc:2,
    capital:"Mexico (Distrito Federal)",
    member_g8:false,
    article:"http://en.wikipedia.org/wiki/Mexico"
},
{
    continent:"Europe",
    countryName:"Spain",
    countryCode:"SP",
    area:504782,
    population:40397842,
    gdp:1029.0,
    independence:new Date(1492,0,1),
    government:"parliamentary monarchy",
    government_desc:4,
    capital:"Madrid",
    member_g8:false,
    article:"http://en.wikipedia.org/wiki/Spain"
},
{
    continent:"Asia",
    countryName:"South Korea",
    countryCode:"KS",
    area:98480,
    population:48846823,
    gdp:965.3,
    independence:new Date(1945,7,15),
    government:"republic",
    government_desc:5,
    capital:"Seoul",
    member_g8:false,
    article:"http://en.wikipedia.org/wiki/South_korea"
},
{
    continent:"Asia",
    countryName:"Indonesia",
    countryCode:"ID",
    area:1919440,
    population:245452739,
    gdp:865.6,
    independence:new Date(1945,7,17),
    government:"republic",
    government_desc:5,
    capital:"Jakarta",
    member_g8:false,
    article:"http://en.wikipedia.org/wiki/Indonesia"
}

];

isc.RestDataSource.create({
    ID: 'countryDS',
    clientOnly: true,
    testData: countryData,
    fields:[
        { name: "continent"},
        { name: "countryName"},
        { name: "area", title: ('area'), type: 'msfUOM', required: true, allowEmptyValue:false},
        { name: "population", title: ('population'), type: 'float',format:',0',required: true  },
        { name: 'gdp', title: ('gdp')},
        { name: "government",title: ('government')},
        { name: "independence",title: ('independence'),type:"date", useTextField:true,required: true},
        { name: 'capital', title: ('capital'), type: 'integer' },
        { name: 'member_g8', title: ('member_g8'), type: 'boolean'},
        { name: "article",title: ('article')}
    ]
});


isc.ListGrid.create({
    ID: "countryList",
    width:500, height:250, top:70,
    autoFetchData: true,
    dataSource: countryDS,
    fields:[
        {name:"countryName", title:"Country"},
        {name:"population", title:"Population", format:",0"},
        {name:"area", title:"Area (1000 ft&sup2;)"}
    ],
    // initial sort on Population, high-to-low
    sortField: 2,
    sortDirection: "descending"
});

isc.DynamicForm.create({
    ID: "exportForm",
    width:300,
    fields: [
        { name: "exportType", title: "Export Type", type:"select", width:"*",
            defaultToFirstOption: true,
            valueMap: { 
                "csv" : "CSV" , 
                "xml" : "XML", 
                "json" : "JSON",
                "xls" : "XLS (Excel97)",
                "ooxml" : "OOXML (Excel2007)"
            }
        },
        { name: "showInWindow", title: "Show in Window", type: "boolean", align:"left" },
        { name: "exportRawValues", title: "Raw Values", type: "boolean", align:"left" }
    ]
});

isc.Button.create({
   ID: "exportButton",
   title: "Export",
   left: 320,
   click: function () {
       var exportAs = exportForm.getField("exportType").getValue();
       var showInWindow = exportForm.getField("showInWindow").getValue();
       var exportRawValues = exportForm.getField("exportRawValues").getValue();
       if (exportAs == "json") {
           // JSON exports are server-side only, so use the OperationBinding on the DataSource
           countryList.exportData({ operationId: "customJSONExport", 
               exportDisplay: showInWindow ? "window" : "download"});
       } else {
           // exportAs is not JSON, so we can set that with requestProperties
           countryList.exportClientData({ exportAs: exportAs, exportRawValues:exportRawValues,
               exportDisplay: showInWindow ? "window" : "download"
           });
       }
   }
});


</script>
</body>
</html>

**mabboud** · 6 Aug 2018, 08:41

Any updates on this matter?

**mabboud** · 13 Aug 2018, 04:35

Hello Isomorphic ...

are you looking into this issue ?

**mabboud** · 10 Sep 2018, 12:12

any updates on this ?

**Isomorphic** · 19 Sep 2018, 12:47

Sorry for the long silence here. We have a fix in progress on this and will follow up when it's available for you to work with.

**Isomorphic** · 4 Oct 2018, 04:34

We have added a new property ListGrid.exportRawNumbers and ListGridField.exportRawNumbers that you can set to explicit false on the field or on the listGrid to get the behavior you want (show the formatted value rather than the raw value in excel export).

These changes will be available as of the next nightly build, dated October 05.

Regards
Isomorphic Software

Announcement

ListGrid ExportClientData Excel different from CSV and XML

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment