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.
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