In the process of parsing digital values from the Excel table, an incorrect value is generated, although everything was correct during the configuration. For example, 0.72 is defined solely as 72.00 Changing global settings does not produce the desired result.
It’s a pity that there is no way to make local settings for each file
Yeah, sorry, unfortunately there's no way of changing the local settings for every file.
However, you can choose the format of the source file in the column settings, so the data is displayed correctly in wpDataTables.
For example, if your float column is set up as 0.72 in the source file, but as 0,72 in wpDataTables, you can go to that column's settings, and change the number format from 15.000,00 to 15,000.00, and it should work fine.
In the process of parsing digital values from the Excel table, an incorrect value is generated, although everything was correct during the configuration. For example, 0.72 is defined solely as 72.00 Changing global settings does not produce the desired result.
It’s a pity that there is no way to make local settings for each file
Hi Alexander
Yeah, sorry, unfortunately there's no way of changing the local settings for every file.
However, you can choose the format of the source file in the column settings, so the data is displayed correctly in wpDataTables.
For example, if your float column is set up as 0.72 in the source file, but as 0,72 in wpDataTables, you can go to that column's settings, and change the number format from 15.000,00 to 15,000.00, and it should work fine.
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
Thank you, Aleksandar!
This problem was resolved unexpectedly :)))
Best regards,
Alexander.
You're welcome, Alexander
Glad I could help.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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