When exporting a table as excel sheet, float values are being exported with the wrong value. Instead of 5.96, I get 596, for example. Column is float(12,2) in DB and set to 2 decimals in wpDataTables.
Hi Bogdan, The issue is with the Number Format setting. When it is 15.000,00 it is not showing Decimal values in Excel output but when it is set to 15,000.00 it is showing decimal values. European standard is 15.000,00 for showing prices. Is this a bug in WpDataTables plugin ?
Hi,
When exporting a table as excel sheet, float values are being exported with the wrong value. Instead of 5.96, I get 596, for example. Column is float(12,2) in DB and set to 2 decimals in wpDataTables.
Hi adityalele55,
Thank you for your purchase.
Can you please send me the link of that table so I can take a look.
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
Hi Bogdan, The issue is with the Number Format setting. When it is 15.000,00 it is not showing Decimal values in Excel output but when it is set to 15,000.00 it is showing decimal values. European standard is 15.000,00 for showing prices. Is this a bug in WpDataTables plugin ?
Hi adityalele55,
The format of the numbers from the settings page should be the same like the format that is entered in the file.
So can you please check if the number format is the same in the settings and in the file from which you created a table.
We did not receive any reports with the number format from the settings.
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