Formatting when importing from Excel is not respected by Datatables and some kind of conversion takes place. See screenshot
No problems when I define columns as "Strings" but then I cannot use this in the charts. Example of this on screenshot where it looks as you multiply with 100. This when defined as float or integer.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
1. Can you first please check if you selected the right Number Format,
in the main plugin settings?
It needs to match the same number format and number of decimals as from the source Data.
2. If that does not help, we currently have an issue that happens only in Manual tables ( same as for imported tables);
Our developers confirmed they are aware of it, they will work on improving this in the future.
By default, all float columns for Manual Tables will initially be created in the database with 4 decimals.
I can't say an ETA when it will be improved,
but you follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the time being, we have two possible workaround solutions when we need a higher number of decimal places:
1. If you want to get it working as Float Type, with proper numeric sorting,
you can change the column setting directly in your database for the table.
Here is my example via PhPMyAdmin with screenshots for setting 6 decimal places.
( My apology if you already know how to do this, i will share it just to be safe)
First, we check what is the SQL table name, in the Editing tab:
-
Then we find the table in PhPMyAdmin and edit the column(s) we need to have 6 decimals :
-
Change the Length/Values for the Float Column from initial "16,4" to the decimal number you need;
in this case "16,6" - that will allow you to get 6 decimals without issues.
-
Once you go back to the table in our plugin, you will be able to have 6 decimals in this column for new rows.
-
2.
Or you can set up a new column as String type, it will also work that way to display the value,
but then you won't get proper numeric sorting.
Let me know if that makes sense and if you have any questions. Thank you
Formatting when importing from Excel is not respected by Datatables and some kind of conversion takes place.
See screenshot
No problems when I define columns as "Strings" but then I cannot use this in the charts. Example of this on screenshot where it looks as you multiply with 100. This when defined as float or integer.
What to do?
Kind regards
Lars Pehrsson
Attached files: TMS.png
Hi, Lars.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
1. Can you first please check if you selected the right Number Format,
in the main plugin settings?
It needs to match the same number format and number of decimals as from the source Data.
2. If that does not help, we currently have an issue that happens only in Manual tables ( same as for imported tables);
Our developers confirmed they are aware of it, they will work on improving this in the future.
By default, all float columns for Manual Tables will initially be created in the database with 4 decimals.
I can't say an ETA when it will be improved,
but you follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the time being, we have two possible workaround solutions when we need a higher number of decimal places:
1. If you want to get it working as Float Type, with proper numeric sorting,
you can change the column setting directly in your database for the table.
Here is my example via PhPMyAdmin with screenshots for setting 6 decimal places.
( My apology if you already know how to do this, i will share it just to be safe)
First, we check what is the SQL table name, in the Editing tab:
-
Then we find the table in PhPMyAdmin and edit the column(s) we need to have 6 decimals :
-
Change the Length/Values for the Float Column from initial "16,4" to the decimal number you need;
in this case "16,6" - that will allow you to get 6 decimals without issues.
-
Once you go back to the table in our plugin, you will be able to have 6 decimals in this column for new rows.
-
2.
Or you can set up a new column as String type, it will also work that way to display the value,
but then you won't get proper numeric sorting.
Let me know if that makes sense and if you have any questions. 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