Export To CSV Resulting File Contains Excel =HYPERLINK() Function

book

Article ID: 197794

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

In the Classic UX, when exporting to CSV a list that contains a link, the resulting file will contain the value with the Microsoft Excel =HYPERLINK() function. It is expected that CSV be exporting the value (in plain-text) instead, not an Excel formula ("Export to Excel" should be used for this). Some cells will generate an error message that the string is longer than 255 characters.

Steps to Reproduce:

  1. Go to any portlet that allows Export to CSV, like Project List.
  2. Ensure that there are columns that contain a link (normally, at least 'Project' name links to the project properties page).
  3. Click on Options > Export to CSV

Expected Results: CSV contains only plain-text values, such as '4G Upgrade Readiness'
Actual Results: CSV contains Excel formulas for attributes that use links, such as '=HYPERLINK("http://xxx/niku/nu#action:projmgr.projectProperties&id=5047176","4G Upgrade Readiness")'. 

Clicking in the cell may also generate a message to indicate 'Text values in formulas are limited to 255 characters'.

Cause

This issue has been reported to Engineering as DE5735.

The length of the text string in the cell formula may vary and could be longer than what is seen in Clarity because the export action will prepend SSO URL causing the cell formula text to be greater than 255 characters.

Microsoft Excel has a limitation of 255 characters in cells.

Environment

This issue has been reported for Clarity 15.8.1.

Resolution

Resolved in 15.8.1.1. 

DE57354 is marked as a duplicate to DE57188 and is resolved in patch #1 for 15.8.1. 

The export will show the field value label with the hyperlink as a cell formula. 

Exporting data will now only export the hyperlink as a cell formula if the length is less than 255 characters. 

If the length of the hyperlink is greater than 255 characters, the cell will only contain the string value of the field - no hyperlink. 

If SSO is enabled, this could cause hyperlinks to get constructed with more than 255 characters upon export, and therefore, no hyperlink is exported.