Bug 63941 - Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1
Summary: Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipul...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-20 07:02 UTC by Sushmita Nag
Modified: 2019-11-29 09:48 UTC (History)
0 users


Attachments
Sample file with the hyperlink[Non-Working file] (111.17 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-11-20 07:02 UTC, Sushmita Nag 		Details
Sample file with the hyperlink[Working file] (125.92 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-11-20 07:04 UTC, Sushmita Nag 		Details
Sample program (1.50 KB, text/plain)
2019-11-29 09:46 UTC, Sushmita Nag 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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]

Regards,
Sushmita
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 ?

Regards,
Sushmita
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.