hello, I am using Google sheets api as a data source for one of my tables. When I choose integer or float, the data is not showing correctly on the table, even if the data type on the source table is correct. How do we fix this?
Especially for float, everything seems to show up wrong and we are not able to let users filter much less even show those columns because it just looks plain wrong.
Need some assistance, thanks!
For example, the first row should say 34.0 and not 340,00
hello, I am using Google sheets api as a data source for one of my tables. When I choose integer or float, the data is not showing correctly on the table, even if the data type on the source table is correct. How do we fix this?
Especially for float, everything seems to show up wrong and we are not able to let users filter much less even show those columns because it just looks plain wrong.
Need some assistance, thanks!
For example, the first row should say 34.0 and not 340,00
Attached files: Screen Shot 2023-05-15 at 8.08.44 PM.png
Hi, Miko Lee.
Apology for a late reply.
Can you please change your Number Format setting, in the main plugin settings?
I believe this should fix that issue.
Let me know how it goes. Thanks.
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, Miko Lee.
And i just forgot to add, that is for the Number Format, but if you also need only one decimal point,
you can change the number of decimals in the main plugin settings as well.
Let us know if that helps.
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