Apache OpenOffice (AOO) Bugzilla – Issue 108773
Misinterpretation of relative path information from EXCEL should be avoided by open-input filter
Last modified: 2013-01-29 21:49:41 UTC
* extract example.zip * open /example/folder2/spreadsheet.xls in OOo Calc * on mouseover the Hyperlink is shown file:///.../example/folder1\text.txt => with OOo for Linux this Hyperlink could not be resolved
Created attachment 67480 [details] example.zip
baumux: It is not complicated to create a not working hyperlink, but is that an OOo bug? Please contribute a step by step instruction how that hyperlink has been created and explain why you think that that's an OOo issue!
@rainerbielefeld: The point is that the Excel import filter breaks the link. The link is correct and working in MS Excel.
I did some further tests with spreadsheet.xls, pls. see detailed results in attached PDF. Excel viewer screenshot shows MS's adventuresome ideas concerning link syntax. I don't believe that there is a REAL bug, in a simple way OOo does everything correct: - recognizes hyperlink - encodes special characters (%5C / REVERSE SOLIDUS) - adds absolute path information. This will be handled correctly as a file link with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]", although the syntax is crude. But it seems that LINUX will not accept such links. Indeed, a solution might be that OOo corrects or repairs such WIN specific hyperlinks, but the question is: will EXCEL eb able to handle that? My test with excel Viewer shows that Excel seems to accelt such a "folder1/text.txt ÿÿ" syntax @baumux: Is the link in the sample document the result of an automatic URL recognition or has it been inserted using a hyperlink dialogue? In the second case, a fix would be some "must", in the fist case IMHO it's more or less an enhancement.
Created attachment 67582 [details] Pls. see comments from rainerbielefeld Wed Feb 3 15:42:53 +0000 2010
The link is the result of using a normal hyperlink dialog in Excel (Insert->Hyperlink->File...). The interesting thing is that not all relative hyperlinks are converted incorrectly by OOo. The situation is the following: We have the folders C:\Folder1 which contains the file File.txt and we have the folder C:\Folder2 which contains our Excel file. In this case the following happens with relative links: 1. "..\Folder1\File.txt" in Excel becomes "file:///C:/Folder1\File.txt" in Calc (This is bad!) 2. "..\File.txt" in Excel becomes "file:///C:/File.txt" in Calc (This is correct!) 3. If we just add another backslash the conversion also works, so "..\Folder1\\File.txt" in Excel becomes "file:///C:/Folder2/../Folder1//File.txt" (This seems to be okay with Linux) baumux will add another example file later on which will demonstrate this.
Created attachment 67583 [details] Extended example directory structure. Both links have been created via the hyperlink dialog. One link is broken after import, the other is correct.
Small correction to my comment above: Of course, C:\ must also contain File.txt for case 2 to be correct. But the point was just that in some cases when a relative link contains ".." followed by another directory the backslash is converted incorrectly whereas if ".." is followed by the filename it seems to work.
Sorry. The previous example was the old one again.
Created attachment 67584 [details] This time for real: Example with 2 hyperlinks. One is imported correctly, the other isn't