Support Article

Export to Excel does not work with multiline cells as expected



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:

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


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.