[Bug 63941] New: Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 63941] New: Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

            Bug ID: 63941
           Summary: Hyperlink broken[reference isn't valid] of excel file
                    once excel 2007 manipulated using poi-4.0.1
           Product: POI
           Version: unspecified
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: POI Overall
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Created attachment 36890
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36890&action=edit
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

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63941] Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #1 from Sushmita Nag <[hidden email]> ---
Created attachment 36891
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36891&action=edit
Sample file with the hyperlink[Working file]

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63941] Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

Sushmita Nag <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #2 from Sushmita Nag <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63941] Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #3 from Sushmita Nag <[hidden email]> ---
hi Team,

Could you please respond to this thread ?

Regards,
Sushmita

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63941] Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #4 from Sushmita Nag <[hidden email]> ---
Created attachment 36906
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36906&action=edit
Sample program

Sample program

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63941] Hyperlink broken[reference isn't valid] of excel file once excel 2007 manipulated using poi-4.0.1

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #5 from Sushmita Nag <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]