Bug 63941

Summary: Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1
Product: POI Reporter: Sushmita Nag <snag>
Component: POI OverallAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Sample file with the hyperlink[Non-Working file]
Sample file with the hyperlink[Working file]
Sample program

Description Sushmita Nag 2019-11-20 07:02:52 UTC
Created attachment 36890 [details]
Sample file with the hyperlink[Non-Working file]

hi Team,

As per our use case, we are importing a .xlsx file in our application and while importing the file we do some manipulation of custom properties using apache-poi-4.0.1. However, after importing, we observed, that the hyperlink present in the excel sheets are broken. We are not sure what caused this. Could you please share your thoughts on the same ?

Attached the file - Please open the first sheet named as Information & Guidelines [And click on the hyperlink - IT DR Plan Template - On-Premises , IaaS & PaaS Systems]

Comment 1 Sushmita Nag 2019-11-20 07:04:01 UTC
Created attachment 36891 [details]
Sample file with the hyperlink[Working file]
Comment 2 Sushmita Nag 2019-11-20 07:20:01 UTC
One more thing to mention, the hyper links name consist of spaces. And when the file gets manipulated by poi, we could see the spaces in the hyperlink got replaced by %20. Hence, it is not working. And when we edit the link and save, the link works.
Comment 3 Sushmita Nag 2019-11-26 07:59:28 UTC
hi Team,

Could you please respond to this thread ?

Comment 4 Sushmita Nag 2019-11-29 09:46:37 UTC
Created attachment 36906 [details]
Sample program

Sample program
Comment 5 Sushmita Nag 2019-11-29 09:48:35 UTC
Attached the sample program where in we could add/modify certain custom properties of attached MS excel file and hence reproduce the issue by opening the generated output file and clicking on the hyperlinks contained in the file.