Hi, we have wpDatatables on a page. It uses at dot (".") for thousands separators, so when you download an Excel spreedsheet 1400 becomes 1,4, when you open it in Excel. If I use CSV export and import that into Excel it becomes correct (1400 is 1400, not 1,4). I have gotten a complaint from the customer we built the site for and hope you can help me with this.
Hi, we have wpDatatables on a page. It uses at dot (".") for thousands separators, so when you download an Excel spreedsheet 1400 becomes 1,4, when you open it in Excel. If I use CSV export and import that into Excel it becomes correct (1400 is 1400, not 1,4). I have gotten a complaint from the customer we built the site for and hope you can help me with this.
Kind regards
Olav A Dybdahl
Ignore this. I found the setting
Hello Olav
Thank you for your purchase, and for letting us know that the issue has been resolved.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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