Summary: | Hyperlink with a non-breaking space throws java.lang.IllegalStateException: The hyperlink for cell A2 references relation rId2, but that didn't exist! | ||
---|---|---|---|
Product: | POI | Reporter: | lakshmi <lakshmi.nchandana> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | REOPENED --- | ||
Severity: | normal | CC: | ameetchaubal, devscorpio2001, kayulai2, onealj, sivasubbareddy |
Priority: | P2 | ||
Version: | 3.8-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: |
Excel file containing the hyperlink with a non-breaking space
Excel file with a non-breaking space hyperlink Excel sample with hyperlinks Excel file containing invalid hyperlink hyperlink error |
Description
lakshmi
2012-05-23 21:13:23 UTC
Created attachment 28827 [details]
Excel file containing the hyperlink with a non-breaking space
Comment on attachment 28827 [details]
Excel file containing the hyperlink with a non-breaking space
please ignore this attachment.
Unable to attach the excel file. To reproduce the error, copy/paste the below in an excel file nobody@nowhere.uk nobody@nowhere.com I can't reproduce it. Please try again to attach a sample file with a nbsp . Yegor (In reply to comment #3) > Unable to attach the excel file. > > To reproduce the error, copy/paste the below in an excel file > > nobody@nowhere.uk > nobody@nowhere.com Created attachment 28830 [details]
Excel file with a non-breaking space hyperlink
Fixed in r1403195. I included your sample in our collection of test files. Yegor Created attachment 30385 [details]
Excel sample with hyperlinks
Excel sample with hyperlinks
We have tried with version 3.9 and 3.10 beta. Seems still issue is there. Attached a sample file the japanese hyperlink with a space. Are you able to produce a unit test, similar to the one Yegor did for r1403195, which shows how the problem still remains? That will help us track down what's still incorrect. Created attachment 30683 [details]
Excel file containing invalid hyperlink
Comment on attachment 30683 [details]
Excel file containing invalid hyperlink
This file contain a invalid email address hyperlink which can reproduce the probelm.
Fixed by svn rev r1563540. Although the last sample file containing the invalid hyperlink seems to be a bit hypothetical, I think it's better to receive/return an invalid-url, in case such a malformed uri is really generated, opposed to throwing an IllegalStateException It seems that the bug still exists in 3.10 final. I got a file from a customer where value like "xxx@company.com; TEL: +001-123-456789" is given as email address hyperlink in it. Try to import this file a IllegalStateException is thrown at the beginning and there is no way to correct the value afterwards in program. I have been facing the same issue as well and I am using POI 3.10.1. The excel that I have has autogenerated hyperlinks and some of them have spaces in the hyperlink. Created attachment 32471 [details]
hyperlink error
I am getting a similar error on workbook.cloneSheet
The hyperlink for cell O2 references relation rId1, but that didn't exist!
|