Results 1 to 1 of 1

Thread: Ext 6.2 gridexporter plugins issue!

  1. #1
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default Answered: Ext 6.2 gridexporter plugins issue!

    The export data is null when the data is '0'. I use the saveDocumentAs method by the way .I want to know if anyone have the same issue.Please help me,thanks!
    code:
    saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  2. code: saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  3. #2
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default

    saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  4. #3
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default

    Code: saveDocumentAsExcel:function(store,columns,titleName,container){ if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  5. #4
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default

    cod : saveDocumentAsExcel:function(store,columns,titleName,container){ if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  6. #5
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default Code:

    saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  7. #6
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default Gridexporter issue,if grid contains ZERO(0) or 0.0

    Gridexporter issue,if grid contains ZERO(0) or 0.0

    suppose to grid store data contains ZERO(0) or 0.0, when export grid as excel xlsx ,display empty instead of ZERO or 0.0.
    saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  8. #7
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default Gridexporter issue,if grid contains ZERO(0) or 0.0

    if grid contains ZERO(0) or 0.0, it will be show null
    code:
    saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  9. #8
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default

    code:
    saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  10. #9
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default

    saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

  11. #10
    Sencha Premium User
    Join Date
    May 2017
    Posts
    9
    Answers
    1

    Default Gridexporter issue,if grid contains ZERO(0) or 0.0

    code: saveDocumentAsExcel:function(store,columns,titleName,container){
    if(container){
    container.removeAll();
    var gridTemp = Ext.create('Ext.grid.Panel', {
    store: store,
    columns: columns,
    hideHeaders: true,
    plugins: 'gridexporter',
    renderTo: document.body
    });
    container.add(gridTemp);
    store.load({
    scope: this,
    callback: function(records, operation, success) {
    if (success) {
    var fileName=titleName+'_'+Ext.Date.format(new Date(), 'Ymd');
    gridTemp.saveDocumentAs({type:'xlsx',mimeType:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',title:titleName,fileName:fileName+'.xlsx'});
    setTimeout(function () {
    container.removeAll();
    },5000);
    }
    }
    });
    }
    }

Similar Threads

  1. [FIXED] Gridexporter issue,if grid contains ZERO(0) or 0.0
    By nagaraju ch in forum Ext JS 6.x Bugs
    Replies: 6
    Last Post: 20 Oct 2017, 2:41 AM
  2. Replies: 3
    Last Post: 1 Jan 2014, 8:55 AM
  3. [CLOSED] Grid Plugins CSS Issue with Accessibility Theme
    By Mark.B in forum Ext:Bugs
    Replies: 2
    Last Post: 16 Nov 2013, 2:56 AM
  4. add multiple plugins or dynamically adding the plugins
    By gokulpotluri in forum Ext: Q&A
    Replies: 1
    Last Post: 15 May 2013, 4:52 AM
  5. Replies: 5
    Last Post: 5 Feb 2013, 11:12 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •