I want to import a google sheet as a either an excel, CSV, or as a URL, but whenever I do so, all the formatting in the cells is stripped away.
I have cells that contain some text that are underlined and in bold, but when I import this is stripped and all spaces are eliminated on the site.
I tried importing this google sheet that is editable but when I provided the URL, the following page showing the columns was blank, with no error message.
Is there a way that formatting within cells can be retained when importing?
Hey,
I want to import a google sheet as a either an excel, CSV, or as a URL, but whenever I do so, all the formatting in the cells is stripped away.
I have cells that contain some text that are underlined and in bold, but when I import this is stripped and all spaces are eliminated on the site.
I tried importing this google sheet that is editable but when I provided the URL, the following page showing the columns was blank, with no error message.
Is there a way that formatting within cells can be retained when importing?
Thanks
HI pateconcepts,
Thank you for your purchase.
Can you please send me the link of that spreadsheet so I can take a look.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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 Mark,
No problem.
First thing i noticed in the spreadsheet is formating.
You can not have any of the formating in the file because it is not supported for creating our tables.
Beside the formating our plugin can not create table if there is also some formulas, functions, merged cells, empty column headers in the file etc.
So can you please clear all of the formating and then try again.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hey,
Thanks for quick reply. That's fine. We can work around that.
Is it possible to add a custom column after spreadsheet import and include a button in that column containing a download link for a PDF?
So that we can include a PDF with each entry?
Thanks Bogdan,
Mark
Hi Mark,
This is just a workaround for now because Google have bad practice to change something and not give feedback about the changes.
About the custom column:
Sorry to disappoint you but unfortunately something like this is not possible with the plugin build in features.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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