Success! Looks like we've fixed this one. According to our records the fix was applied for
EXTJS-23405
in
6.2.2 .
Sencha User
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'
});
}
});
I can't reproduce this. What version of Ext is this on?
https://fiddle.sencha.com/#view/editor&fiddle/20ch
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.
Sencha Premium User
This bug was filed as EXTJS-23405 and has been fixed already and is available in the nightly.
Sencha Premium User
I want to know how could I fix this bug?
Sencha Premium User
I have the same issue. Should I upgrade the ext version from 6.2.1 to 6.5?
Sencha Premium User
Originally Posted by
xiaoyuren
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.
Sencha User
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?