Support Article

Export to Excel does not work with multiline cells as expected

SA-30579

Summary



Export to Excel of columns containing multi-line text values from list views does not work correctly.

Each line in the multi-line text value is placed in a separate cell rather than being kept together in a single cell in the spreadsheet.


Error Messages



Not applicable


Steps to Reproduce



Do an export to Excel of a report that has multi-line text values. The formatting option for keeping them in a single cell does not work with list views.


Root Cause



A defect in Pegasystems’ code or rules:

​E
xcel exporting ignores new line of each cell because pzDisplayPropValue is ignoring the Html tags.

Resolution



Apply HFix-30577.
 

Published November 18, 2016 - Updated November 25, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.