Results 1 to 7 of 7

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

    Success! Looks like we've fixed this one. According to our records the fix was applied for EXTJS-23405 in 6.2.2.
  1. #1
    Sencha User
    Join Date
    Sep 2016
    Location
    hyderabad
    Posts
    2

    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.
    This code sample :
    CODE:
    Ext.application({
    name: 'Fiddle',


    launch: function () {
    var gridStore = Ext.create('Ext.data.Store', {
    fields: ['name', 'desc', 'city'],
    data: [{
    name: 'nagaraju',
    desc: 'nagaraju',
    age:0
    }, {
    name: 'nagaraju',
    desc: 'nagaraju',
    age:0
    },
    {
    name: 'nagaraju',
    desc: 'nagaraju',
    age:0
    }, {
    name: 'nagaraju',
    desc: 'nagaraju',
    age:0
    }, {
    name: 'nagaraju',
    desc: 'nagaraju',
    age:0
    }, {
    name: 'nagaraju',
    desc: 'nagaraju',
    age:0.1
    }, {
    name: 'nagaraju',
    desc: 'nagaraju',
    age:0.01
    }, ]
    });


    var gridPanel = Ext.create('Ext.grid.Panel', {
    columns: [{
    text: 'Full Name',
    dataIndex: 'name'
    }, {
    text: 'Description',
    dataIndex: 'desc',
    flex: 1
    }, {
    text: 'Age',
    dataIndex: 'age'
    }],
    store: gridStore,
    height: 200,
    width: 400,
    plugins: [{
    ptype: 'gridexporter'
    }],
    renderTo: Ext.getBody()
    });


    gridPanel.saveDocumentAs({
    type: 'xlsx',
    charset: 'Shift-JIS',
    title: 'Sample',
    fileName: 'sample.xlsx'
    });
    }
    });

  2. #2
    Sencha Premium User evant's Avatar
    Join Date
    Apr 2007
    Location
    Sydney, Australia
    Posts
    19,255

    Default

    I can't reproduce this. What version of Ext is this on?

    https://fiddle.sencha.com/#view/editor&fiddle/20ch
    Attached Images Attached Images
    Twitter - @evantrimboli
    Former Sencha framework engineer, available for consulting.
    As of 2017-09-22 I am not employed by Sencha, all subsequent posts are my own and do not represent Sencha in any way.

  3. #3
    Sencha Premium User
    Join Date
    Dec 2009
    Location
    Iasi, Romania
    Posts
    159

    Default

    This bug was filed as EXTJS-23405 and has been fixed already and is available in the nightly.

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

    Default

    I want to know how could I fix this bug?

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

    Default

    I have the same issue. Should I upgrade the ext version from 6.2.1 to 6.5?

  6. #6
    Sencha Premium User
    Join Date
    Dec 2009
    Location
    Iasi, Romania
    Posts
    159

    Default

    Quote Originally Posted by xiaoyuren View Post
    I have the same issue. Should I upgrade the ext version from 6.2.1 to 6.5?
    You can either get the nightly for 6.2.x or upgrade to 6.5.

  7. #7
    Sencha User
    Join Date
    Jun 2011
    Posts
    74

    Default

    I have the same issue. Using version 6.0.1.250.

    When exporting the value 0 (ZERO) is exported has empty... the data Type for my column is INT.

    Does someone know a work around?

Similar Threads

  1. Replies: 2
    Last Post: 15 Nov 2015, 11:08 PM
  2. Replies: 0
    Last Post: 6 Nov 2015, 6:49 AM
  3. Replies: 1
    Last Post: 13 Dec 2013, 12:03 AM
  4. Replies: 2
    Last Post: 14 Jun 2013, 2:44 PM
  5. Paging Grid issue: pagetoolbar is a issue
    By wwwlinux in forum Ext 1.x: Help & Discussion
    Replies: 5
    Last Post: 28 Feb 2007, 5:48 PM

Posting Permissions

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