Idea Document Link is still not exporting as URL if greater than 255 chars

book

Article ID: 209210

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

When using url greater than 255 characters long in Idea Document Link, the exported excel field is still a text field.

Ref: 15.8.1 Release Notes -> Increased Hyperlink Length When You Export to Excel (Classic PPM)

Environment

Release : 15.9.1

Component : CA PPM SAAS STUDIO

Resolution

Yes in 15.8.1 we released the enhancement to support 2085 characters, however, soon after customers complaint as it was not working correctly. Essentially Excel has a limitation that it will only support 255 characters for hyperlink. So when we were sending the 2085 characters, Excel would trim it down to 255 characters and customers would see broken link. This caused more frustration and customers said it is better to not show the link than to give a broken link. Hence in patch 1 we reverted the changes back to how it was prior to 15.8.1. 

Thus what you are seeing is correct that any link longer than 255 will not see the hyperlink.