I have noticed that when I export a table in Excel format and I have a column that is a number, when the file is open in Excel the column is a string then you have to convert to number manually. Is there a way to have this working without conversion ?
Unfortunately something like that is not possible and it is necessary to change column type manually, at the moment. We are working on this "feature" where creating charts will automatically recognize the column type ( especially dates) but for the upcoming version the users will need to change it manually.
Hi Bogdan,
I have noticed that when I export a table in Excel format and I have a column that is a number, when the file is open in Excel the column is a string then you have to convert to number manually. Is there a way to have this working without conversion ?
Thanks
Best Regards
Riccardo Accetta
Hi Riccardo,
Thank you for your purchase.
Unfortunately something like that is not possible and it is necessary to change column type manually, at the moment.
We are working on this "feature" where creating charts will automatically recognize the column type ( especially dates) but for the upcoming version the users will need to change it manually.
Best regards.
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