Hello! I have faced with the following problem. I need to render values with 5 numbers after the comma. I've defined 5 of decimal places for the float numbers in settings.But only 4 numbers are rendered. Values are rounding off to 4 decimals.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID where you have float column so I can take a look.
I noticed that you opened the same ticket twice, so due to our support policy I must kindly ask you to not do that in future. I will close the other one and we will continue here.
Can you please check in your database is that column type set to the INT or Float? Also can you please check in wpdatatables settings page which number is set for decimal places ( attachment).
Column type is set to the Float and I've set 5 for decimal places.
You can check this issue in the sandbox. Create the table with the float numbers and set 5 for decimal places. Than try to input for example 0.12345. And you can find that there would be 0.12340 in the table, but not 012345.
I see now. Can you please tell me the numbers from your database for that float column. I assume that it is Float (16,4) can you please try to change it to Float (16,5).
When you go to your phpmyadmin and select that table you will see that float column. Then change in data base the number like from the attachment to be 16,5.
Hello! I have faced with the following problem. I need to render values with 5 numbers after the comma. I've defined 5 of decimal places for the float numbers in settings. But only 4 numbers are rendered. Values are rounding off to 4 decimals.
How can I solve this problem?
Hi victorkovalenko,
Thank you for your purchase.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID where you have float column so I can take a look.
I noticed that you opened the same ticket twice, so due to our support policy I must kindly ask you to not do that in future. I will close the other one and we will continue here.
Thank you for understanding.
Best regards.
Kind Regards,
Miloš Jovanović
[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
Hi Bogdan,
Please check this problem in the sandbox (http://sandbox.wpdatatables.com/wp-admin/). It seems that the problem can be featured on the any table.
When you create the float with 5 number after the comma, the float is rounding off to 4.
Hi victorkovalenko,
Thank you for your purchase.
Can you please check in your database is that column type set to the INT or Float?
Also can you please check in wpdatatables settings page which number is set for decimal places ( attachment).
Best regards.
Kind Regards,
Miloš Jovanović
[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
Column type is set to the Float and I've set 5 for decimal places.
You can check this issue in the sandbox. Create the table with the float numbers and set 5 for decimal places. Than try to input for example 0.12345. And you can find that there would be 0.12340 in the table, but not 012345.
Hi victorkovalenko,
I see now.
Can you please tell me the numbers from your database for that float column.
I assume that it is Float (16,4) can you please try to change it to Float (16,5).
Thank you.
Kind Regards,
Miloš Jovanović
[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
Dear Bogdan
For example I use 0.25275; 0.27138; 0.30431 for the float column.
Please explain what are Float (16,4) and Float (16,5)?
Hi victorkovalenko,
When you go to your phpmyadmin and select that table you will see that float column.
Then change in data base the number like from the attachment to be 16,5.
Let me know the result.
Kind Regards,
Miloš Jovanović
[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
I've done it! Everything is OK. Thank you for your help!
Hi victorkovalenko,
I am glad that now everything is working fine.
You are welcome.
Best regards.
Kind Regards,
Miloš Jovanović
[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