Tell us what you are trying to do? need output to be one row per record
Is there any documentation that you are following?
Is there a similar example that we can see?
What is the link to your site? hidden link
the output has " double quotes around each line of content plus a pair of <br></br> within a single cell:
<td>
"content"<br><br />
"content"<br><br />
</td>
so when copying from browser to excel, each <br><br /> creates a row within the cell. Need to have one row per record.
correction:
the <br><br/> were code errors.
so the double quotes around each line in the cell seem to be the problem?
I get a 404 on that link, I assume I need to be logged in to see it.
However, related to the issue, I am not entirely sure what your goal is.
You cannot copy paste content from a browser to an excel sheet without also copying in some additional syntax that will likely be different from browser to browser and excel program to excel program.
For example, if you copy paste from a formatted document in a browser to Google Translate all formats are gone - clean output is produced.
If you paste the same to a Google DOC it will be kept.
As you see this is not related to Toolset in its nature but rather to formats, and copy-paste behaviour of different OS and programs.
I am sorry that we can likely not help with this problem unless it is somehow related to Toolset?
I think it might be though - can you check inspector on the rows that have multiple items? i think it's the double quote sets inside the cell causing it. can you give me a private post to give you login?
As said the url is a 404.
Double quotes inside cells is a little vague, usually those should be something added in the text, or eventually, it's some HTML entity?
I have added private details, but as said, copy paste is not something controlled by Toolset.
The simplest test to demonstrate this is to disable Toolset on the site and copy-paste again. The issue will likely as well happen.
TD Tables can be produced with custom HTML if you did that now in a View's Loop Wizard and would need to replicate it clean:
hidden link
yes, i think it's pretty clean - i can't find anything - i've replicated the view and removed everything except that one column - and removed everything other type of formatting or extra stuff - and still it outputs each line in the cell as a separate row.
When I copy from that table I get:
Web Dev/Maint SFOTB Go Page Alameda:
add logos, map, full listings
No double quotes are used.
I see through in the code what you probably mean, as there are "" wrapped around Go Page Alameda:
But that is not anything related to Toolset. It is the browser making this.
In fact, you cannot copy that out from it, at least, not when I try this over here.
It seems to affect only "[wpv-post-title]:" part.
This is simply because it has no formatting - so the browser puts it in a ""
If you add a p tag around it, it'll not happen
Can you test this?
It is BTW the exact same if you insert any text in WordPress Classic editor and go to remove the p tag that is added automatically by WordPress.
It's the browser adding those "".
you're right. but I'm zeroing in on a workaround: in IE browser, using
br {mso-data-placement:same-cell;}
in css of the output takes care of the single <br> - great improvement - i can copy and paste from the IE browser into excel and have one record per row.
except: where a double hard return is entered, the output shows <p> tag instead of <br> - still trying to address this issue with css but if you have any ideas of how to turn the <p> into <br><br><br> in views, that would take care of it too.
thanks!
solved - or at least a workaround. works only in IE browser.
in View:
css:
br {mso-data-placement:same-cell;}
tr {white-space:pre-line}
js:
$("p").each(function () {
$(this).replaceWith($(this).text() + "<br><br><br>");
});
