I am having a very strange problem and am not sure what to do to correct it. I have built a table with several columns and am using an Excel spreadsheet as the source file. The column named "Rank" does not show the correct data on the table. All other columns are correct. At first I thought it was putting the data in the wrong positions but upon further investigation I found that the data is incorrect. Any ideas on what might be causing this? I have included a screenshot of the table and a copy of the source file.
Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables. We removed all formatting from the file and the table is created normally.
If you need to show numbers as integer or float but still have the percentage sign please remove the percentage sign from the source file and also empty values as - and when you create table you can add cell prefix or suffix in column settings.
Please find attached the reformatted file you can use to create your table.
Thank you for your help. I did know to format the cells in WpDataTables. The problem I had is when I removed the percentage formatting from my file it would not display correctly in WpDataTables. For instance, if I have 83.90% on my file and remove the formatting it changes it to 0.8390. If I then put in the percentage sign in the suffix for the column settings the number in the cell in WpDataTables is 0.8390%, not 83.90%. However, I took the file you sent back to me and changed the cells that needed to be percentages back to percentages but left all other formatting out and it is working properly so it must have been some of the other formatting causing the problem. But, for my future reference, is there a solution to the problem I indicated above with the example of the 83.90% number?
If you typed in 83.90 that would be what is displayed in the table, but you had some custom format that displays floats as percentages and that is why the result was different.
Do let us know if there is anything else we can assist you with.
Hi,
I am having a very strange problem and am not sure what to do to correct it. I have built a table with several columns and am using an Excel spreadsheet as the source file. The column named "Rank" does not show the correct data on the table. All other columns are correct. At first I thought it was putting the data in the wrong positions but upon further investigation I found that the data is incorrect. Any ideas on what might be causing this? I have included a screenshot of the table and a copy of the source file.
Hi Edward
Thank you for reaching out to us.
Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables. We removed all formatting from the file and the table is created normally.
If you need to show numbers as integer or float but still have the percentage sign please remove the percentage sign from the source file and also empty values as - and when you create table you can add cell prefix or suffix in column settings.
Please find attached the reformatted file you can use to create your table.
Hi,
Thank you for your help. I did know to format the cells in WpDataTables. The problem I had is when I removed the percentage formatting from my file it would not display correctly in WpDataTables. For instance, if I have 83.90% on my file and remove the formatting it changes it to 0.8390. If I then put in the percentage sign in the suffix for the column settings the number in the cell in WpDataTables is 0.8390%, not 83.90%. However, I took the file you sent back to me and changed the cells that needed to be percentages back to percentages but left all other formatting out and it is working properly so it must have been some of the other formatting causing the problem. But, for my future reference, is there a solution to the problem I indicated above with the example of the 83.90% number?
Hi Edward
If you typed in 83.90 that would be what is displayed in the table, but you had some custom format that displays floats as percentages and that is why the result was different.
Do let us know if there is anything else we can assist you with.