[Libreoffice-bugs] [Bug 48463] New: (regression) LibreOffice calc creates malformed links to external Excel-sheets after reopen docs

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 48463
           Summary: (regression) LibreOffice calc creates malformed links
                    to external Excel-sheets after reopen docs
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.1 Release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
          Severity: blocker
          Priority: high
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: harz.g.dot at gmail.com


Created attachment 59672
  --> https://bugs.freedesktop.org/attachment.cgi?id=59672
Excel-sheet with malformed external links

libreoffice:
  Installed: 1:3.5.1-1ubuntu1~lucid1
  Candidate: 1:3.5.1-1ubuntu1~lucid1
  Version table:
 *** 1:3.5.1-1ubuntu1~lucid1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ lucid/main
Packages
        100 /var/lib/dpkg/status

In LibreOffice Calc 3.5.1-1ubuntu1~lucid1 (PPA) and 3.5.2-1 (Debian unstable)
there are problems with malformed links to external Excel-sheets. 

Make a source.xls and a merged.xls. 
Type in source.xls 
[A1]number
[A2]A 
[A3]B 
[B1]value
[B2]11
[B3]22
Type in merged.xls 
[A1]number 
[A2]A 
[A3]B 
[B1]value 
[B2]25
[B3]45
Make in  merged.xls
[C1]diff 
[C2]=B2-'file:///tmp/source.xls'#$sheet1.B2
[C3]=B3-'file:///tmp/source.xls'#$sheet1.B3

The sheet merged.xls shows now in [C2]14 and [C3]23.

If you close merged.xls and reopen it, you get a message "… contains links …
should they be updated?" and an error.
=B3-'file:///tmp/tmp/source.xls/'#$sheet1.B2

The path-name was saved (or reloaded) wrong into [C2] and [C3].
As LO-users will/must cooperate with MSO-users, they can't use LibreOffice 3.5
because the malformed links to external sheets.
To let all switch to ods-sheets is not an option "at the office".

There is no work-around atm with other formats like xlsx. 

I tested in 3.4.4 links to other sheets - works fine there (tested with
Oneiric). (I heard also about normal behaviour in Debians LibreOffice calc
1:3.4.6-2.)

libreoffice:
  Installed: 1:3.4.4-0ubuntu1
  Candidate: 1:3.4.4-0ubuntu1
  Version table:
 *** 1:3.4.4-0ubuntu1 0
        500 http://nl.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages
        100 /var/lib/dpkg/status
        1:3.4.3-3ubuntu2 0
        500 http://nl.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

Can we go back to the behaviour of 3.4.x to make/save/reload links to external
sheets?

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