tabs characters lost on workbook to excel

[Bridge24]

We have some cells with tabs (\t) character we need to export to excel.

When exporting, the tabs are removed after calling the function workbook.toDataURLAsync.  

Can be reproduced here

https://dojo.telerik.com/@foxontherock/ATUzudIL

 

[Peter Milchev]

Hello,

The reason for the observed behavior is the internal logic that strips similar characters. Here is the function that strips the tabs:

function stripFunnyChars(value) {
    return String(value)
        .replace(/[\x00-\x09\x0B\x0C\x0E-\x1F]/g, "") // leave CRLF in
        .replace(/\r?\n/g, "\r\n");                   // make sure LF is preceded by CR
}

Regards,
Peter Milchev
Progress Telerik