Bug 62778 - url-encoded in internal links (Target/TargetURI) for xlsx excel cannot to recognize
Summary: url-encoded in internal links (Target/TargetURI) for xlsx excel cannot to rec...
Status: NEEDINFO
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.0.x-dev
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-29 13:04 UTC by Andre de Souza Pinto
Modified: 2018-12-22 17:10 UTC (History)
0 users



Attachments
Decode the Target tag before zip part marshallers (879 bytes, patch)
2018-09-29 13:04 UTC, Andre de Souza Pinto
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Andre de Souza Pinto 2018-09-29 13:04:12 UTC
Created attachment 36176 [details]
Decode the Target tag before zip part marshallers

The troubleshoot occurs when we write/save an excel xlsx file and this file use white spaces inside the name of sheets.
For example:
Performance Resume => Performance%20Resume
Performance Resume 2 => Performance%20Resume%202

Excel cannot to recognize this link in shapes, cells, buttons, ...

To resolve this trouble I debug the code in eclipse for a week more or less and found the source that do it.

I just put one line for decode the string of Target.

Follow the diff in attachment

Thanks for attention
Comment 1 PJ Fanning 2018-09-29 15:34:20 UTC
Can you provide a junit test case?