You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/11/20 07:02:52 UTC

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

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: dev@poi.apache.org
          Reporter: snag@opentext.com
  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #5 from Sushmita Nag <sn...@opentext.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #3 from Sushmita Nag <sn...@opentext.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #4 from Sushmita Nag <sn...@opentext.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

--- Comment #1 from Sushmita Nag <sn...@opentext.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63941

Sushmita Nag <sn...@opentext.com> changed:

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

--- Comment #2 from Sushmita Nag <sn...@opentext.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org