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:
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'.
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.
This issue has been reported for Clarity 15.8.1.
Resolved in 220.127.116.11.
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.
Details in the documentation: