Rich Text Format (RTF) Exporting to CSV

book

Article ID: 209979

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Exporting Rich Text Format fields into CSV causes data to scatter across lines.
The content of the field is scattered across the number of lines the RTF field occupies.

STEPS TO REPRODUCE:

1. Go to Studio > Objects > Project object
2. At the Attributes tab, create a Rich Text Field (RTF) type attribute
3. Enable it for the Modern UX
4. Go to the Modern UX > Blueprints
5. Add the field to the project blueprint.
6. On a project associated to the blueprint above, add some content on the RTF field


7. Go to the project list
8. On the list view add the RTF column to the view
9. Move the RTF column to be one of the first columns on the view


10. Export the list view to CSV

Expected Results: The content of each line exported to be placed on a single row
Actual Results: The RTF column content is scattered across several lines

Cause

This was analyzed by Engineering through DE60014. This is not a bug

Environment

Any Clarity release

Resolution

CSV in plain text editor shows lines as wrapped. When opened with advanced editor like Numbers / Google Sheets, it shows up correctly.

It is not a Clarity issue, but linked to the tool used to open the CSV file.

Notepad++ export:

Google Sheet export:

Attachments