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

             Bug #: 45286
           Summary: Wrong format for references when saving as .xlsx
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.5 release
          Platform: x86-64 (AMD64)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: [email protected]
        ReportedBy: [email protected]


When creating or saving a file as .xlsx, with cells referenced to other files,
the format saved is wrong, turning the spreadsheet unusable.

LibO 3.4.5
OO: 340m1 Build:502



Format when defining the cross file reference:

='file:///I:/SAMPLE SHEET 2012.xls'#'Sheet 1'.N42 



Format when reopening the .xlsx file:

=['file:///i:/sample sheet 2012.xls']$#REF!.N42

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to