Return-Path: 
 <dev-return-23020-apmail-poi-dev-archive=poi.apache.org@poi.apache.org>
X-Original-To: apmail-poi-dev-archive@www.apache.org
Delivered-To: apmail-poi-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 5F1F79CF1
	for <apmail-poi-dev-archive@www.apache.org>;
 Mon, 20 Feb 2012 18:38:54 +0000 (UTC)
Received: (qmail 48836 invoked by uid 500); 20 Feb 2012 18:38:54 -0000
Delivered-To: apmail-poi-dev-archive@poi.apache.org
Received: (qmail 48778 invoked by uid 500); 20 Feb 2012 18:38:53 -0000
Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@poi.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@poi.apache.org>
List-Post: <mailto:dev@poi.apache.org>
List-Id: <dev.poi.apache.org>
Reply-To: "POI Developers List" <dev@poi.apache.org>
Delivered-To: mailing list dev@poi.apache.org
Received: (qmail 48770 invoked by uid 99); 20 Feb 2012 18:38:53 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Feb 2012 18:38:53 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.115] (HELO eir.zones.apache.org) (140.211.11.115)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Feb 2012 18:38:51 +0000
Received: by eir.zones.apache.org (Postfix, from userid 80)
	id 4CAC1507B3; Mon, 20 Feb 2012 18:38:30 +0000 (UTC)
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: DO NOT REPLY [Bug 52716] New: Hyperlink parser is overly strict
 causing document open to fail for doc which works in other tools
Date: Mon, 20 Feb 2012 18:38:29 +0000
X-Bugzilla-Reason: AssignedTo
X-Bugzilla-Type: new
X-Bugzilla-Watch-Reason: None
X-Bugzilla-Product: POI
X-Bugzilla-Component: XSSF
X-Bugzilla-Keywords: 
X-Bugzilla-Severity: normal
X-Bugzilla-Who: tfmorris@gmail.com
X-Bugzilla-Status: NEW
X-Bugzilla-Priority: P2
X-Bugzilla-Assigned-To: dev@poi.apache.org
X-Bugzilla-Target-Milestone: ---
X-Bugzilla-Changed-Fields: 
Message-ID: <bug-52716-47293@https.issues.apache.org/bugzilla/>
X-Bugzilla-URL: https://issues.apache.org/bugzilla/
Auto-Submitted: auto-generated
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
X-Virus-Checked: Checked by ClamAV on apache.org

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: tfmorris@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org