[#4846] - xlsx exporter sending corrupt hyperlinks' data

Category:
Bug report
Priority:
High
Status:
Closed
Project: Severity:
Critical
Resolution:
Not Fixable
Component: Reproducibility:
Always
Assigned to:

Dear All;
We are using Jasperserver to run monthly reports of a considerable size.
The reports contain a hyperlink in of the columns and we need to export them in xlsx format because of the size of the data.
- When we the report for a shorter time, resulting into a smaller report of less than 4000 rows, and export to xlsx we encounter no problem. The report is properly downloaded and can be opened with MS Excel.

- But we run the report with more data that results in a report of more 4000 rows; after downloading, on trying to open the exported xlsx file MS Excel states that the file contains ivalid data and further asks if i would like it corrected.
If i choose i yes, MS Excel reports during the correction of the data, some parts were removed a log containg the following is displayed;

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error245400_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\myusername\AppData\Local\Temp\e1_broker_report-9.xlsx'</summary>
-<additionalInfo>
<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>
</additionalInfo>
-<removedFeatures summary="Following is a list of removed features:">
<removedFeature>Removed Feature: Hyperlinks from /xl/worksheets/sheet2.xml part</removedFeature>
</removedFeatures>
</recoveryLog>

I have read around and many experiencing a similar problem claim the issue is in the JRXlsxExporter. But from my own observations, it seems like the size of the report has something to do with the problem. I think so because for slightly smaller reports, we do not observe the problem.

v6.0
martin.kavuma's picture
Joined: Sep 8 2014 - 7:03am
Last seen: 8 years 4 months ago

4 Comments:

#1

I'm having the same issue with larger files. Was there any resolution to this?

#2
  • Assigned:nobody» shertage
#3
  • Resolution:Open» Not Fixable
  • Status:New» Resolved

According to the current documentation, the maximum number of hyperlinks allowed in a sheet is 66,530:
https://support.office.com/en-us/article/excel-specifications-and-limits...

In case of large files, if the number of hyperlinks exceeds this limit an error will be thrown. Try to reduce as much as possible the number of hyperlinks in the generated sheet. Or export data with One Page Per Sheet property enabled and limit the number of rows per page.

#4
  • Status:Resolved» Closed
Feedback