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. This also goes for hyperlinks. The plugin can read the text, but not the link behind it. If you need wpDataTables to pull the hyperlink, you need to change the Google Spreadsheet, so it uses HTML tags, like:
<a href="www.google.com">Google</a>
The empty cells are probably some cells that used to contain data, but no longer do, so the cells are different from other empty cells (the ones that were not edited before). You would need to clear all formatting from your file.
Tables linked to an existing Google Spreadsheet are not editable, nor are they saved in the database.
1. My data is in a Google Sheet
2. In the fourth column, there should be publications names linked to websites. The text is there, but the links are all missing
3. Contents of cells in columns one, two, and four should be bold. They are not. How can I make them bold?
4. There are empty cells at the top of the table. Why? How do I get rid of them?
5. I paid for Pro version in part so I could edit the tables on the website, but I can't edit anything. Why? How can I fix this?
Thanks
S
Hello Sharon
Thank you for your purchase.
Like mentioned in our documentation about Google Spreadsheet tables:
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. This also goes for hyperlinks. The plugin can read the text, but not the link behind it. If you need wpDataTables to pull the hyperlink, you need to change the Google Spreadsheet, so it uses HTML tags, like:
The empty cells are probably some cells that used to contain data, but no longer do, so the cells are different from other empty cells (the ones that were not edited before). You would need to clear all formatting from your file.
Tables linked to an existing Google Spreadsheet are not editable, nor are they saved in the database.
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