To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91833
------- Additional comments from [EMAIL PROTECTED] Wed Sep 3 04:27:08 +0000 2008 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
