Debian Bug report logs - #671774
/usr/bin/libreoffice: LibreOffice calc creates malformed links to external XLS-sheets

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: HarzG <harz.g.dot@gmail.com>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: /usr/bin/libreoffice: LibreOffice calc creates malformed links to external XLS-sheets

Date: Sun, 06 May 2012 22:15:02 +0200

[Message part 1 (text/plain, inline)]

Package: libreoffice-common
Version: 1:3.5.2-6
Severity: important
File: /usr/bin/libreoffice

Dear Maintainer,

   * What led up to the situation?
-> upgrade LO from 3.4.x to 3.5.x

   * What exactly did you do (or not do) that was effective (or 
ineffective)?
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 and 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].

I guess it's not a save-wrong but a open/reload-wrong issue.

   * What was the outcome of this action?
tested LO 3.4.x in Ubuntu 11.10, no problem
tested LO 3.5.x in Windows XP SP3, no problem

tested LO 3.5.x in Debian sid and Ubuntu 10.04(ppa)/12.04
-> malformed links to external XLS-sheets (ODS-sheets are ok)

   * What outcome did you expect instead?
If LO-users will/must cooperate with MS Office-users, they can't use 
LibreOffice
3.5.x 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.
Switch to Gnumeric (all plugins on) won't help, because Gnumeric won't 
read external XLS-sheets.

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


-- System Information:
Debian Release: wheezy/sid
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.3-4.towo.2-siduction-amd64 (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages libreoffice-common depends on:
ii  dpkg                                                  1.16.3
ii  libreoffice-style-galaxy [libreoffice-style-default]  1:3.5.2-6
ii  libreoffice-style-tango [libreoffice-style]           1:3.5.2-6
ii  ure                                                   3.5.2-6

Versions of packages libreoffice-common recommends:
pn  libexttextcat-data  3.2.0-2
pn  xfonts-mathml <none>

Versions of packages libreoffice-common suggests:
ii  libreoffice-style-crystal <none>
ii  libreoffice-style-hicontrast <none>
ii  libreoffice-style-oxygen <none>
ii  libreoffice-style-tango       1:3.5.2-6

-- no debconf information

Regards,
HarzG

[LO_calc_malformed_xls_sheets.zip (application/zip, attachment)]

Message #14 received at 671774@bugs.debian.org (full text, mbox, reply):

From: Stéphane Aulery <lkppo@free.fr>

To: 671774@bugs.debian.org

Subject: /usr/bin/libreoffice: LibreOffice calc creates malformed links to external XLS-sheets

Date: Sat, 30 Sep 2017 16:11:44 +0200

Hello,

I can't reproducre this bug with LO 5.4.1-1.

Seems fixed.

Regards,

-- 
Stéphane Aulery

Message #27 received at 671774-done@bugs.debian.org (full text, mbox, reply):

From: saulery@legtux.org

To: 671774-done@bugs.debian.org

Subject: /usr/bin/libreoffice: LibreOffice calc creates malformed links to external XLS-sheets

Date: Mon, 13 May 2019 13:35:42 +0000

hello,

Still valid with 6.0.6. Please follow this bug at :

https://bugs.documentfoundation.org/show_bug.cgi?id=54204

Regards,

-- 
Stéphane Aulery

Message #36 received at 671774-done@bugs.debian.org (full text, mbox, reply):

From: Stéphane Aulery <lkppo@free.fr>

To: 671774-done@bugs.debian.org

Subject: /usr/bin/libreoffice: LibreOffice calc creates malformed links to external XLS-sheets

Date: Tue, 20 Dec 2022 02:39:49 +0100

Version: 1:6.4.2-1

This bug have been fixed in 6.4.0.

-- 
Stéphane Aulery

Send a report that this bug log contains spam.