jquery-table2excel icon indicating copy to clipboard operation
jquery-table2excel copied to clipboard

Exporting 2 decimal places

Open panickerr opened this issue 9 years ago • 5 comments

The plugin while exporting a percentage value with one decimal place automatically suffixes a 0, thus making it 2 decimal places even though its not there in the html. ie if table shows: 94.1% the exported table shows : 94.10%

panickerr avatar Aug 18 '16 06:08 panickerr

I have resolved this issue, shall put the solution tommorow

angadsule avatar Aug 22 '16 19:08 angadsule

Are you sure the plugin is the cause? Unless my code has really diverged from my memory, I think the values are passed in without data-types meaning that Excel is interpreting the data how it sees fit. I'd think that to "fix" the behavior you're seeing, the plugin would have to do data-type management that could be passed to excel; either through auto-detection (very difficult) or explicit data-type declarations being added to each element that needed it and then passed through.

rainabba avatar Aug 22 '16 19:08 rainabba

Looking forward to seeing your solution. Please be sure to pull again before submitting your PR, I just merged some PRs that were outstanding.

rainabba avatar Aug 24 '16 22:08 rainabba

"<!--[if gte mso 9]><xsl:template name='styles'>"

angadsule avatar Aug 25 '16 18:08 angadsule

i m not able to paste the code..please mail me your email id...on [email protected]

angadsule avatar Aug 25 '16 18:08 angadsule