Export to Excel does not work with multiline cells as expected
SummaryExport 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 MessagesNot applicable
Steps to ReproduceDo 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 CauseA defect in Pegasystems’ code or rules:
xcel exporting ignores new line of each cell because pzDisplayPropValue is ignoring the Html tags.
Published November 18, 2016 - Updated November 25, 2016