We are developing an application using intensively wpDataTables for a Spanish company (comma separated decimal numbers). When exporting to Excel decimal number fields (float, two decimals in wpDataTable field configuration), this field change its value x 100.
Example:
(in database): 165,00 (varchar)
(in wpDataTable): 165,00 (float, 2 decimal positions)
You need to have the same number format configured in Excel file (locally on your computer) in order for the numbers to carry over correctly.
The ticket you're referring to is very old, and the issue has been fixed since then. However, since wpDataTables and the database formats are similar, the only thing that could cause this behavior is the wrong format in Excel.
Hi,
Similar to this old ticket: https://tmsplugins.ticksy.com/ticket/1355715/
We are developing an application using intensively wpDataTables for a Spanish company (comma separated decimal numbers). When exporting to Excel decimal number fields (float, two decimals in wpDataTable field configuration), this field change its value x 100.
Example:
(in database): 165,00 (varchar)
(in wpDataTable): 165,00 (float, 2 decimal positions)
(in Excel): 16500
Is there any way to avoid this bug?
Thank you in advance.
Best regards.
Hello javierwpdl
Thank you for your purchase.
You need to have the same number format configured in Excel file (locally on your computer) in order for the numbers to carry over correctly.
The ticket you're referring to is very old, and the issue has been fixed since then. However, since wpDataTables and the database formats are similar, the only thing that could cause this behavior is the wrong format in Excel.
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