excel - Scientific large number display after jquery generation -
excel - Scientific large number display after jquery generation -
i using tableexport plugin, when export table xls 1 of columns contains big numbers f.e 760000322300000939115730
, after export appears 7,60e+23
, console.log shows <td>760000322300000939115730</td>
. have no thought why happens so. manually cell formatting (for number formatting ) shows 760000322300000000000000 , text formatting 7,6e+23
line responsible generation
excel += "<td>" + parsestring($(this))+ "</td>";
https://github.com/kayalshri/tableexport.jquery.plugin/blob/master/tableexport.js
i got no ideas why happens. tips?
excel += '<td>="'+parsestring($(this))+'"</td>';
forces display string
jquery excel xls
Comments
Post a Comment