Export to excel problem whit numbers as 560,00 appears in excel as 56000 without "," ot "."

cffranchi

Hi everybody! I have a simple problem when export data from datatable to excel, for example if you have a number like 560,00 when open the document created in excel this number appear like 56000.

I'm using the following version of datatables, jquery and buttons plugins
src="//code.jquery.com/jquery-1.12.4.js"
src="https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"
src="https://cdn.datatables.net/buttons/1.2.4/js/dataTables.buttons.min.js"
src="//cdn.datatables.net/buttons/1.2.4/js/buttons.flash.min.js"
src="//cdn.datatables.net/buttons/1.2.4/js/buttons.html5.min.js"

Thanks in advance!
Carlos

allan

Can you try DataTables 1.10.15 and Buttons 1.3.1 (the current releases) please? If that doesn't help, please link to a test case showing the issue.

Allan

cffranchi

Thanks Allan, I'll try with DT 1.10.15 and B 1.3.1 and tell you later.

cffranchi

Allan, I could solve it.
Thanks again.
Carlos