Please note that Table Export Tools are based on a 3rd party HTML5 library, and there are some limitations in this library which we cannot change.
One of them is that you need to configure the number format in wpDataTables so that it matches the format in your Excel installation. Please make sure that locale settings are the same, and that the default number and date formats are the same everywhere. That's the only way of resolving this issue.
The table shows number with a comma as decimal separator. However, when I want to export the table excel deletes the commas.
Hello Mounir Al Honsali.
Thank you for your purchase.
Please note that Table Export Tools are based on a 3rd party HTML5 library, and there are some limitations in this library which we cannot change.
One of them is that you need to configure the number format in wpDataTables so that it matches the format in your Excel installation. Please make sure that locale settings are the same, and that the default number and date formats are the same everywhere. That's the only way of resolving this issue.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables