А lot of hyperlinks in xlsx document creating by report shedule

0

Hello, everybody!

Could sombody help me with my issue. I have a big report with a large number of hyperlinks. And sometimes, when I open resulting xlsx-file a get Excel error: "Excel found unreadable content in "MyReport.xls'.  Do you want to recover the contents of this workbook?  If yo trust the source of this workbook, click Yes"

I've noticed that maximum number of hyperlinks when file opened correctly is 65530. If I reduce the number of hyperlinks file eventually opens. Why there is such restriction on number of hyperlinks in xlsx?

 

ivitokhin_1's picture
Joined: Mar 2 2016 - 4:03am
Last seen: 10 months 1 week ago

4 Answers:

0

The MS Excel format specifications indicate a limitation of hyperlinks number per sheet, indeed.

To disable all hyperlinks in the Excel document you could use the following property: net.sf.jasperreports.export.xls.ignore.hyperlink = true in your JRXML.

Altenatively, you can handle each hyperlink separately by using a hyperlink parameter with the same name as the property above, in order to make some of them disabled while the other are enabled. More information about this export property/parameter you can find here: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.ignore.hyperlink

I hope this helps,

Sanda

shertage's picture
1930
Joined: Sep 26 2006 - 8:06pm
Last seen: 1 month 6 days ago
0

Are you exporting to "xls" or to "xlsx"? xls is an older version with smaller number of maximum rows restriction. It seems like you're selecting "xls" and not "xlsx".

hozawa's picture
47007
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 months 1 week ago
0
Hi, hozawa. No, I use not paginated xlsx.
ivitokhin_1's picture
Joined: Mar 2 2016 - 4:03am
Last seen: 10 months 1 week ago
0

Sanda, thank you a lot.

ivitokhin_1's picture
Joined: Mar 2 2016 - 4:03am
Last seen: 10 months 1 week ago
Feedback