Export to Excel: Portlet TSV cells

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When I export a Clarity portlet that contains TSV fields into Excel, the output is not aligned with the portlet itself

The Clarity portlet looks like:

And the Excel output extracts all the data into a single row like:

In Clarity, you can see the TSV attributes one below another.

In Excel all attributes and corresponding values are exported on a single row.

Resolution

This is working as designed.

Clarity displays the data as:

(TSV Field name = MyTSV)
Row1 ..... TSV field attribute 1 ... <data>
Row1 ..... TSV field attribute 2 ... <data>
Row1 ..... TSV field attribute 3 ... <data>

Export to Excel output looks like this:
Row1 ..... TSV field 1 (header label MyTSV)... <data> ..... TSV field 2 (header label MyTSV)... <data> ..... TSV field 3 (header label MyTSV)... <data>

This is the intended behavior.