carriage return in string field does not work

Hi there.

Unfortunately, the HTML5 library we use for table export tools is not customizable, and there are some limitations:

• Only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export
• Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed
• Conditional formatting is not reflected in any of generated export files
• Other front-end extensions cannot be combined with Table Tools. If you have row grouping enabled for the table, or there are some customizations you did yourself, they won’t be reflected in the generated Excel, CSV or PDF document, nor in the clipboard
• When you export tables with the wpDataTables plugin, please note that you can export values, but not formulas. WpDataTables doesn’t support exporting formulas, so a Formula column will be exported only with values; and any calculations of Average, MIN, MAX, and Total will not be exported at all
• Exporting images is not possible at the moment
• You can’t export columns that are hidden – they will not be visible in any exporting or printing tool

Basically, the table tools don’t see any HTML code, and it only exports what it sees. That is why you’re getting raw values, as if there are no breaks in the cells.

Kind regards.

• This reply was modified 5 years, 2 months ago by wpDataTables.

Hi,

maybe the issue is in the library.

For example the table value of the address field have the value in html style

My Name<br>555 City

this look on the webpage correct as

My Name
555 City

but on the print or PDF and so on the <br> in the value ist removed and the output on the printer looks

My Name555 City

In older versions of the WpDataTables it works fine. And unfortunately i don’t see a option to fix this issue. At this time the print output is not readable because the lines are combinded without a newline to a muddle.

Thanks

Hi again.

The issue is with the third party library we use. Like we mentioned, it sees only what’s being displayed on front end. It doesn’t see, and doesn’t recognize the HTML tag, so the output is in line.

Unfortunately, that’s one of the limitations of this library, and although we tried to reach out to their team in order to fix not only this, but other issues we’re having with it, they didn’t respond.

Our team will look into some different solutions in the future, but at the moment there’s no workaround for the issue other than installing third-party PDF plugins to get the output you desire.

Kind regards.