https://issues.apache.org/bugzilla/show_bug.cgi?id=52716
Bug #: 52716 Summary: Hyperlink parser is overly strict causing document open to fail for doc which works in other tools Product: POI Version: 3.7 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P2 Component: XSSF AssignedTo: dev@poi.apache.org ReportedBy: tfmor...@gmail.com Classification: Unclassified Created attachment 28357 --> https://issues.apache.org/bugzilla/attachment.cgi?id=28357 Failing document The attached document fails to open in POI 3.7. From a cursory look in the debugger where the IllegalStateException is being thrown, it looks to me like this can be safely ignored since it's an unused reference. (As an aside, it would be much more polite to your callers to use a checked exception so they'd know it was coming and be able to handle it.) The stack trace is: java.lang.IllegalStateException: A sheet hyperlink must either have a location, or a relationship. Found: <xml-fragment ref="A1" tooltip="Sort on ID" display="ID" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"/> at org.apache.poi.xssf.usermodel.XSSFHyperlink.<init>(XSSFHyperlink.java:72) at org.apache.poi.xssf.usermodel.XSSFSheet.initHyperlinks(XSSFSheet.java:205) at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:159) at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:134) at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:235) at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:190) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189) -- 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-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org