2 columns of data, double, imported but as I formatted the table, it disappears. It's now only showing up as 0s. The same sort of thing happened with the first table I created. I finally just had to get rid of the column which was integer data. I have no idea of how to even troubleshoot this. Please help.
I can't upload the file because it won't allow it. Here's a link to the file https://1drv.ms/x/s!ArA2G811Yu8QivpY62g64Hziu6aXvw?e=ZSBPJI. This plugin is very frustrating. I just tried to bring it in as a csv file and it put everything in one file. Right now I haven't been able to get any table to import correctly.
My guess is that you are having trouble uploading these two columns 2018 Expenses and Total Price Out-State Students 2019-20?
If that is so it will show you 0 since the cells are not formatted correctly and wpDataTables cannot read the values if they are being set to Float or Integer. Please remove the $ sign and add it as a prefix from the column settings or when creating the table change the data type to String and it will display everything in the cell.
Also please avoid using any formatting and styling in the source file, you can make all necessary changes in the table editor.
I hope this helps, please do let us know if you need any further assistance.
2 columns of data, double, imported but as I formatted the table, it disappears. It's now only showing up as 0s. The same sort of thing happened with the first table I created. I finally just had to get rid of the column which was integer data. I have no idea of how to even troubleshoot this. Please help.
Hi Michelle
Thank you for reaching out to us.
Could you please send us the file so we can take a closer look and try to recreate the issue on our end?
I can't upload the file because it won't allow it. Here's a link to the file https://1drv.ms/x/s!ArA2G811Yu8QivpY62g64Hziu6aXvw?e=ZSBPJI. This plugin is very frustrating. I just tried to bring it in as a csv file and it put everything in one file. Right now I haven't been able to get any table to import correctly.
Thank you.
My guess is that you are having trouble uploading these two columns 2018 Expenses and Total Price Out-State Students 2019-20?
If that is so it will show you 0 since the cells are not formatted correctly and wpDataTables cannot read the values if they are being set to Float or Integer. Please remove the $ sign and add it as a prefix from the column settings or when creating the table change the data type to String and it will display everything in the cell.
Also please avoid using any formatting and styling in the source file, you can make all necessary changes in the table editor.
I hope this helps, please do let us know if you need any further assistance.
Thank You! It's working now.
You are most welcome
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!