The 3rd party software that is responsible for export tables in Excel can only see the data (similar to the import, but in this case, it's a 3rd party library).
I forwarded the issue to one of our developers for testing, so hopefully he'll be able to find a workaround for this issue.
I understand what you mean, Clément, but it's nothing we can affect at this stage.
Like I said, a 3rd party HTML5 library is used for exporting tools, and its functionalities don't do this. We will be creating another method of exporting, with more options, so hopefully it will be better in the future.
Ok, the issue is in the 3rd party lib. Thank you for the explanation.
Indeed, I just had a look at the datatables forum, and their ExcelHTML5 export doesn't handle line breaks natively. Even if some users share workarounds.
Using PHPOffice/PHPSpreadSheet to handle the export via PHP might be a better option for WPDT.
We've been short-staffed for quite a while now, and we've just got reinforcements, so I'm sure the development of the plugin will speed up significantly soon.
Hi
When I export a table to Excel, I expect to see the line breaks in the multiline text columns, but they are missing in the Excel file.
Is this a bug or am I missing something?
Thank you
Hello Clément
The 3rd party software that is responsible for export tables in Excel can only see the data (similar to the import, but in this case, it's a 3rd party library).
I forwarded the issue to one of our developers for testing, so hopefully he'll be able to find a workaround for this issue.
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
I understand that Excel can't embed html tags.
But the export should at least convert HTML <br> tags to \r\n, and also keep existing \r\n.
I understand what you mean, Clément, but it's nothing we can affect at this stage.
Like I said, a 3rd party HTML5 library is used for exporting tools, and its functionalities don't do this. We will be creating another method of exporting, with more options, so hopefully it will be better in the future.
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
Ok, the issue is in the 3rd party lib. Thank you for the explanation.
Indeed, I just had a look at the datatables forum, and their ExcelHTML5 export doesn't handle line breaks natively. Even if some users share workarounds.
Using PHPOffice/PHPSpreadSheet to handle the export via PHP might be a better option for WPDT.
I agree with you, Clément
We've been short-staffed for quite a while now, and we've just got reinforcements, so I'm sure the development of the plugin will speed up significantly soon.
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