Relative linking rather than absolute paths between two spreadsheet files would allow for proper cross-platform environment. Steps to reproduce: 1. Open 2 Calc files 2. Navigate to a cell in "file1" and press "=" to begin a link 3. Then click in a cell in "file2" 4. Return to "file1" and complete formula by pressing enter Current behavior: absolute link path created. Expected behavior: relative link path created. i.e. "file:///" to be followed by a relative path from the file location, rather than an absolute path of the entire directory structure higher up. The functionality of Calc works fine when used between computers of the same OS, but when opened on one OS, then attempted on another OS with a different file structure the path linking does not work. Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 6.2; rv:15.0) Gecko/20100101 Firefox/15.0 Browser: Mozilla/5.0 (Windows NT 6.2; rv:15.0) Gecko/20100101 Firefox/15.0 Browser: Mozilla/5.0 (Windows NT 6.2; rv:15.0) Gecko/20100101 Firefox/15.0
also see Bug#51538 for a similar issue in Writer.
NOT reproducible with Server Installation of "LibreOffice 3.6.2.1 rc English UI/ German Locale [Build-ID: ba822cc] on German WIN7 Home Premium (64bit) and a quick test. 0. Menu 'Tools- > Options -> Load/Save -> Save URL relative to file system' hs to be checked if necessary 1. Create spreadsheet, type text "Target" into A1 and safe as "Target.ods" 2. Change Text in A1 to "Link to Target" 3. Select word Target 4. Click hyperlink icon and create hyperlink to "Target.ods" 5. Save document as "Link.ods" and close 6. Rename folder with the 2 documents 7. Reopen "Link.ods" 8. Click link in A1 As expected "Target.ods" opens If reporter's bug would exist, the link should no longer work after having renamed the path. That it still works shows that this report is INVALID, attached test kit should work on every PC. @Jared 1. To get relative path links you have to check Menu 'Tools- > Options -> Load/Save -> Save URL relative to file system' is checked. Without hint whether you have that checked your report is incomplete. 2. Links always are shown with complete path, even when they are relative 3. Please do not use such assertions like "absolute link path created"! What indications did you see? How did you check that? 4. Without comprehensible test results we can do nothing. We know how a file system works, but in your report I can't find any test results. I am pretty sure that you only thought about things that might happen, but did not do a real test. You can get assistance on <http://ask.libreoffice.org/questions/> or on the public users mailing list <users@libreoffice.org>, a mailing list from <http://www.documentfoundation.org/contribution/#lists> or <http://wiki.documentfoundation.org/Local_Mailing_Lists> Please feel free to reopen this Bug if discussion with other users leaded to an assessment that we have a LibO bug and a clear and comprehensible description of the problem due to <http://wiki.documentfoundation.org/BugReport>.
Created attachment 67609 [details] Test Kit Test kit I used for comment before, should work in any folder.