To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91833 Issue #|91833 Summary|Link path with spaces Component|Spreadsheet Version|OOo 2.4.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|dlairmarc
------- Additional comments from [EMAIL PROTECTED] Sat Jul 19 05:41:05 +0000 2008 ------- I've run into a problem with OO2.4.1 at work. I've also tried the current 3.0 dev build m22, same results. All of our spreadsheet files are stored as Excel 2000/03 spreadsheets (.xls) on an NT 4.0 server. Many of them have external links to other spreadsheets. Many of the paths and filenames have spaces in them. Use of Calc breaks the links by converting %20 to %2520 in .xls files opened in Calc, saved as .xls, opened in Excel, saved, and then reopened in Calc. It only seems to happen with network paths, as paths on the local machine do not seem to undergo this conversion. 1. Create file on the server using Excel 2K with links to another spreadsheet with spaces in the link name, save it. 2. Open file in OO, make some change to force an update and resave it back as .xls 3. Open file in Excel, make some change to force an update, resave it. 4. Open file again in Calc, any link with spaces (represented by %20) in the path or filename are now translated to "%2520", rendering the links invalid. This breaks the cell updating for both Calc and Excel from this point forward. It appears that after the first save by Calc, Excel is accepting the %20 generated by Calc to represent the space and preserving the link with the %20 in it, but Calc is reinterpreting the "%" character as a literal and needing to be escaped, thus producing the "%25" and leaving the following "20" as part of the path string. At least, this is what I think is happening. I've tried turning on absolute path names, no difference. Am I missing something? I've tried searching the bug reports and the forums but didn't seem to find anything which seemed to fit. Lot's of issues concerning spaces, but nothing which seems to duplicate this. Has anyone else had this problem? Is there a setting I've missed, or another work-around? At this point, I can't allow anyone using OO to access any of these files due to the corruption of the path/file names. While renaming every directory and or file on the network to remove an embedded spaces and rebuilding all the links in every file would eliminate this issue, it wouldn't be very practical due to the large number of files (1000 +) with multiple links per file. --------------------------------------------------------------------- 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]
