1 Reply Latest reply: May 1, 2017 1:00 PM by Alexander Karlsson RSS

    Number format is not preserved while exporting the data.

    praveena mundolimoole

      Hi All, When the data is exported using below method, the formatting is not preserved in the exported data as shown below. Could anyone please help me out here?

       

      Code to export the data of existing visualization.

       

      var Export = function () {
        table.OnData.unbind(Export);
        table.exportData({ format: 'OOXML', download: false }, function (link) {
        window.open('http' + (config.isSecure ? 's' : '') + '://' + config.host + ':' + config.port + link, '_blank');
        });
      };
      
      
      app.visualization.get($(chart).attr('data-qlik-objid')).then(function (visual) {
        table = qlik.table(visual.model);
        Export();
      });
      

       

      Exported data shown without formatting in excel.

      excel.PNG

      Number format shown properly in the visualization.

      chart.PNG