Hyperlinks missing after a certain number of records when Export to Excel (data Only)

Products

• Clarity PPM SaaS

Issue/Introduction

When a portlet with huge number of records having hyperlinks are exported to excel (data only), not all records are exported with hyperlinks. 

The hyperlinks are missing and they show up as text fields.  

Cause

Steps To Reproduce: 

1. Login to Clarity PPM 

2. Identify a portlet which has more than 25k records and atleast 3 columns with hyperlinks

3. Export to Excel (data only)

Expected: All 25k records are exported with hyperlinks present in all the 3 columns 

Actual: Majority of the rows are exported with hyperlinks but from a certain record, the hyperlinks goes missing and is only text fields.

Resolution

This is a limitation imposed by Microsoft. 

https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

Microsoft supports only 65,530 records with hyperlinks in Excel. 

So in the above example with 3 columns with hyperlinks

21,843 rows * 3 = 65,529 + 1 record in 21,844th row with hyperlink = 65,530 rows will have hyperlinks and rest all records will be text fields without hyperlinks. 

 

The issue is discussed in the communities at

https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=756419

 

In Clarity there is an option under System Options to disable TSV links.

If the TSV are causing the issue because there are so many, you can uncheck the option.