Created attachment 27355 [details] Small Excel file that causes this issue WorkbookFactory.create(fis) throws IllegalStateException when an email hyperlink contains hex C2 A0. java.lang.IllegalStateException: The hyperlink for cell O4 references relation rId1, but that didn't exist! I first encountered this issue with POI 3.6, but tested today with 3.8 beta3. I'm not sure how it was created yet, but MS Excel will create the relationship in xl/worksheets/_rels/sheet1-xml.rels. --Bryan
I've just tried opening this file with POI 3.8 beta 4, and it didn't have any problems, so it looks like it's been fixed as part of a different bug.
Created attachment 29301 [details] Invalid email hyperlink causes error
I have run into this issue as well even using the most up to date apache POI 3.8 as of today, 08/29/2012. I get the error "java.lang.IllegalStateException: The hyperlink for cell C5 references relation rId2, but that didn't exist!" when using the excel file I attached. The invalid cell is C5 as noted in the error, and it seems like the WorkbookFactory.create method in POI errors out when validating or parsing an invalid email hyperlink. I also was able to reproduce it using Bryan's excel file with the invalid blank character after the .uk in cell O4. -- Alan
I could not reproduce this with any of the two files with the latest version 3.13-dev, please try this with a recent nightly build or 3.13-beta1 and reopen this bug if it still happens