I have a table on my website and some of the cells/rows contain values from Google Sheets which are originally 2 lines. When I fetch data into wpDataTables, these two lines of text become 1 line automatically, which if of course not desired for my purpose. Why is that? How to fix this? For example:
Under the column FIXTURES, the cells contain names of two football clubs playing the match against each other. In Google Sheets it is like this:
Finally it comes a reply but I am afraid to say that it was not professional at all. Did I ever mention anything about merging cells in my ticket? These cells are not merged. Just one single cell. But with two lines of text. As simple as that.
A single cell and two lines of text. That is how I would like it but your wpDataTables makes these two lines into one line but I don't want it that way. Why does wpDataTables do that and how to solve this?
Hello,
I have a table on my website and some of the cells/rows contain values from Google Sheets which are originally 2 lines. When I fetch data into wpDataTables, these two lines of text become 1 line automatically, which if of course not desired for my purpose. Why is that? How to fix this? For example:
Under the column FIXTURES, the cells contain names of two football clubs playing the match against each other. In Google Sheets it is like this:
Team one
Team two
But in wpDataTables it is converted to:
Team one Team two
I am confused why your plugin should do this.
Hello again, any reply to this one? Very important for my project...
Hi Edwin,
thank you for reaching out to us
Please check the formatting of these cells in the Google Sheet, as wpDataTables does not support merging cells, so it should not do that.
Also, please send me the table access.
Hello
Finally it comes a reply but I am afraid to say that it was not professional at all. Did I ever mention anything about merging cells in my ticket? These cells are not merged. Just one single cell. But with two lines of text. As simple as that.
A single cell and two lines of text. That is how I would like it but your wpDataTables makes these two lines into one line but I don't want it that way. Why does wpDataTables do that and how to solve this?
Hi Edwin,
thank you for the kind reply
I was referring to cells because you advised that there was a combination of text (which usually happens with cell text - merging into one).
In this case you would need to insert <br> tag where you want the text to be broken down in two (HTML break)
In the sheet it would look like this:
Team one <br> Team two
When saved, it will show:
Team one
Team two