RPE Excel - Attribute with multiple lines (carriage returns)
Hi,
when using RPE to export requirements, some attributes in the datasource are multi-line. The XML datasource uses 
 to identify a new line, but in the excel output this is ignored and the result is a all lines combined into a single line (with no escape characters).
|
One answer
Hi Glyn,
If You will add String.fromCharCode(10); at the end of the line and it will encode new line proper way.
Just do text+"String.fromCharCode(10);
Hope it is solving Your problem.
Bartek
Comments
Glyn Costello
commented Jul 22 '21, 11:10 a.m.
Just to double check...
The attribute value in the datasource is
"Here is line one
Here is line two"
I want to it to print in my Excel as
Here is line one
Here is line two
Bartosz Chrabski
commented Jul 22 '21, 11:58 a.m.
Try is
text.replace("
", String.fromCharCode(10)); |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.