As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
Hi there,
We're importing a number column from a linked Google spreadsheet but, when the number is brought into the data table, it's decimal point is moved.
i.e:
23.00
becomes
2.300,00
I can see the settings for the decimal place, but that only affects the zeros after the comma.
I've attached a screenshot showing input and output.
Any thoughts or ideas welcomed.
Kind regards
James
Hi James.
You can set the column type to be string and it'll display the values as they are being displayed in Google Spreadsheet.
If you need it to be Float after all, you'd need to change the number format in main settings of wpDataTables from 15.000,00 to 15,000.00. Both floats need to be the exact same format type in order for our plugin to display it correctly.
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