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
Created attachment 36891 [details] Sample file with the hyperlink[Working file]
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.
hi Team, Could you please respond to this thread ? Regards, Sushmita
Created attachment 36906 [details] Sample program Sample program
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.