poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 53043] Hyperlink relations are duplicated when saving XSSF file
Date Thu, 05 Apr 2012 23:02:20 GMT

--- Comment #2 from David Cross <cross22@llnl.gov> 2012-04-05 23:02:20 UTC ---
Opening and saving an XSSF workbook using ss.usermodel results in all hyperlink
relations being duplicated in file/xl/worksheets/_rels/sheet.xml.rels. For
example create a worksheet (excel or poi) with a single cell entry & hyperlink.
This file will have a single relation entry in the location mentioned above. 
Open file and save file with or without making modifications.  Now notice that
again in the location given above there is a second hyperlink relation in the
xml. This issue does not seem to effect how files are accessed, however this
has become a critical issue for me as i have a file with ~5000-10000 hyperlinks
that is opened and saved repeatedly. This results in all of the links being
duplicated each time and it doesn't take long before the xml.rels file size
exceeds several hundred Mb. This in turns seriously degrades performance.

Note opening file in excel and re-saving removes all duplicate rels entries.

Attached are xlsx files before and after opening/saving in poi.

Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message