https://bugs.freedesktop.org/show_bug.cgi?id=70970

          Priority: medium
            Bug ID: 70970
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: Links to cell in separate spreadsheet break on save
                    with doubled PATH to file -  only OSX only xls format
          Severity: normal
    Classification: Unclassified
                OS: Mac OS X (All)
          Reporter: bmc...@muskokaauto.com
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.0.2.2 release
         Component: Spreadsheet
           Product: LibreOffice

Cell references are broken on save in xls format


New Spreadsheet
Put just 'Hi Mom' in A1
Save in home folder as file.ods

New Spreadsheet
Type in A1  
='file:///Users/me/file.ods'#$Sheet1.A1
Replace {me} with your actual user name.
Works as expected up to this point

Save as file2.xls

Close file2.xls, reopen, say yes to update links, and voila... busted
cell A1 now shows a doubled up path.
='file:///Users/me/Users/me/file.ods'#$Sheet1.A1


Note that if you save file2 as .ods it works fine
Note also if you do this using LO 4.1 on Windows it works fine

Pretty sure bug exists in multiple versions of LO as it was about a year ago I
first noticed without pinning down exactly what's happening...

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to