Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Link path with spaces | ||
---|---|---|---|
Product: | Calc | Reporter: | dlairmarc <marc> |
Component: | save-export | Assignee: | AOO issues mailing list <issues> |
Status: | UNCONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | amy2008, elish, issues |
Version: | OOo 2.4.1 | Keywords: | needhelp |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
dlairmarc
2008-07-19 06:41:05 UTC
dlairmarc, I can't reproduce it in DEV300_m28 on WinXP. Maybe I misunderstood your description. If possible, please confirm it again. I can not reproduce this. But I'm not using a NT4.0 server, I'm using a Samba file server under Linux. Will this affect the result? I'm trying to reproduce this outside of our network environment to narrow down what causes this. I'm wondering what the process is that outputs the path and inserts the %20 and when it gets brought back in, is reinterpreted and takes the %20 as something other than a space. This seems to be the real problem. Reparsing the saved link with the embedded %20 seems to be where the problem is. I'm hoping I can create some sample files to upload so they can be examined. Marc I've been trying to define this outside our work environment and think I have it narrowed down to where it's easier to reproduce. The "Save URLs relative to" options under Load/Save are unchecked to create absolute paths. (Relative paths create a whole different problem on a network) OS: XP sp3 OOo: tested under 2.4.1 and DEV300m29 My test setup: parent directory: "d:/temp/master.xls" first subdirectory: "d:/temp/sub 08/target 2.xls" second subdirectory: "d:/temp/sub temp/target file.xls" Note the space(s)followed by a numeral in the first subdirectory path. Note the space(s) in the second subdirectory path are followed by letters. Link created in master.xls to first subdirectory: ='file:///D:/temp/sub 08/target 2.xls'#$Sheet1.A1 Link created in master.xls to second subdirectory: ='file:///D:/temp/sub temp/target file.xls'#$Sheet1.B1 Close both files. Reopen the master.xls file. Allow the links to be updated. The linked cells are now #NA The link to the first subdirectory file is now: ='file:///D:/temp/sub%252008/target%25202.xls'#$Sheet1.A1 The link to the second subdirectory file is now: ='file:///D:/temp/sub%2520temp/target%2520file.xls'#$Sheet1.B1 I can do a search and replace on the %2520 string, replacing with either a single space or %20 to recover the broken links, but saving and reopening causes the problem all over again. I can't reproduce using relative links, but that causes severe path problems in a network where the links are scattered all over the file server. I hope this helps someone to reproduce and confirm this issue. Marc |