When we export a wp table in excel and the Numbers are euros are converted with error. I' m using a Italian currency in the setting of the plug in, and when I export in Excel format the value is not correct. For example in the table the number is 88,00 € and in the excel table is 8.800
Please take a look at our documentation on Table Export Tools. These functionalities are based on a 3rd party HTML5 library, and there are some limitations:
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.
Conditional formatting is not reflected in any of generated export files.
Also, the formatting has to be the same both in wpDataTables and in Excel. So if you have a Float in wpDataTables (88,00), you need to set the same format in Excel.
Hi
When we export a wp table in excel and the Numbers are euros are converted with error. I' m using a Italian currency in the setting of the plug in, and when I export in Excel format the value is not correct. For example in the table the number is 88,00 € and in the excel table is 8.800
Do you know how to fix?
Thanks
Hello Skirank.
Please take a look at our documentation on Table Export Tools. These functionalities are based on a 3rd party HTML5 library, and there are some limitations:
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.
Conditional formatting is not reflected in any of generated export files.
Also, the formatting has to be the same both in wpDataTables and in Excel. So if you have a Float in wpDataTables (88,00), you need to set the same format in Excel.
I hope this helps.
Best regards.
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