i have some issue for exporting table to excel, when the data set to "integer" (with separator thousand) 3 digit/ thousand data lost. (e.g 300.000 in front end table become only 300 in excel)
and also when data type "image" exporting data to excel become empty, i need that image also exported to excel. is it possible?
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
After further investigation, we found out that 3rd party software that is responsible for exporting tables in excel does not support the European number format. It only works if numbers contain both dot and comma in number. Here is the reference.
This is why Export numbers with commas as decimal separators have issues in the Excel report.
Please use the CSV export button or change column type to string if you have to use this number format.
Alternatively, you could change the number format.
We apologise for the inconvenience.
-
Exporting images is not possible at the moment, but you are able to export them as HTML with the new “Include HTML” option.
-
Let me know if you have further questions. Thank you
Hello There,
i have some issue for exporting table to excel, when the data set to "integer" (with separator thousand) 3 digit/ thousand data lost. (e.g 300.000 in front end table become only 300 in excel)
and also when data type "image" exporting data to excel become empty, i need that image also exported to excel. is it possible?
thank you
Hi, Panji Achmad
Thanks for reaching out to us
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
This is why Export numbers with commas as decimal separators have issues in the Excel report.
Alternatively, you could change the number format.
We apologise for the inconvenience.
-
-
Let me know if you have further questions. Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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