[Libreoffice-bugs] [Bug 32717] New: Wrong cell links when saving in Excel 2003 format

[bugzilla-daemon at freedesktop.org]

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

           Summary: Wrong cell links when saving in Excel 2003 format
           Product: LibreOffice
           Version: LibO 3.3.0 RC2
          Platform: x86-64 (AMD64)
        OS/Version: All
            Status: NEW
          Severity: critical
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: dpierret at bigfoot.com


When we create a cell linked to an other one from an other file, the link is
broken when saving the file in Excel 2003 format.
Ex.: 
- using ODS file format : cell contains :
   ='file:///C:/temp/LibreOffice/calc1.ods'#$Feuille1.A1
  When saved in ODS format, the cell is ok

- when the file is saved in Excel format and we open again the file, the cell
contains :
   ='file:///C:/temp/LibreOffice/file1.xls'#$''.A1
   ==> the sheet name is lost in the link and is replaced by 2 single quotes

Attached are 2 sets :
- one set in ODS format : calc1.ods & calc2.ods
- same set but saved in Excel 2003 format : file1.xls & file2.xls
  => open file2.xls and check the content of the cell B1 => B30.

The issue is reproductible in 3.3.0RC1 and RC2.

I don't remember having the issue with the 3.3.0 Beta levels.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.