Bug 85793 - Multiple links in a single cell work only with left text alignment
Summary: Multiple links in a single cell work only with left text alignment
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2014-11-03 10:05 UTC by Calabar
Modified: 2022-04-29 14:13 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example Document (37.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-03 10:05 UTC, Calabar
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Calabar 2014-11-03 10:05:01 UTC
Created attachment 108828 [details]
Example Document

Calc seems to have a strange behaviour when using multiple links in a single cell.
I tried this solution to generate a sort of clickable index in a large spreadsheet.

If the alignment is "left", the index works fine, each link is connected to its area.
If the alignment is "center" or "right", all the links in the cell result identical to the first one.
This happens both using manual formatting or cell styles.

The problem seems to be easily reproducible. 

I attach an example document. 


Note that OpenOffice has the same problem and MS Office don’t allow multiple links in a single cell. Supposedly the bug afflicts all the versions of Libreoffice Calc.
Comment 1 Terrence Enger 2014-11-03 16:13:10 UTC
Thank you, Calabar, for helping us to improve LibreOffice.  The
spreadsheet you attached illustrates your problem very clearly; it
sets an example for me to follow in my own bug reports.

I observe the problematic behaviour on Windows in a daily build
(2014-11-02), and on Linux in the daily dbgutil bibisect repo version
2014-11-03 and in the 43all bibisect repo version oldest.

This report is similar to bug 48803 in that the behaviour of a
hyperlink depends on the alignment of text in the cell, but I am not
quite ready to mark that one as a duplicate:
(1) Bug 48803 reports a problem with just one link per cell.
(2) The problem reported in bug 48803 is that links in cells with
    justification Centered, Right, and Distributed are completely
    ineffective.
(3) The example in the attachment to bug 48803 is a http: URL.

Terry.
Comment 2 Calabar 2014-11-04 09:24:16 UTC
Thanks Terry. 

I want to add two things (I thought I wrote that, but apparently I did not): 
- When I change the alignment, the operation is not destructive, and the original target of the link is preserved. If I change the alignment to "left", the original links return to work properly again. 
- If I access the cell containing the multiple links in "edit mode", the links seems to work properly even if the alignment is not left. But only in edit mode. 

PS: as Calc has an "edit mode" for the cells, would it be better to access a link with a simple click instead than with CTRL+Click?
Comment 3 Robinson Tryon (qubit) 2015-12-14 05:40:07 UTC Comment hidden (obsolete)
Comment 4 Xisco Faulí 2016-09-14 14:47:47 UTC
Only regressions should use the keyword 'preBibisect'. Removing it...
Comment 5 Zineta 2017-09-12 06:46:26 UTC
Tested in new versions:LO 5.2; LO 5.3: LO 6.0.  OS:WIN7 

Confirming still the same behavior like LO 3.5. - multiple links in a single cell are possible only in left cell alignment.
Comment 6 Zineta 2017-09-13 10:27:17 UTC
Also tested in OOo 3.3.0 and LO 3.3.0, considering it existed before I set up Vesion  to inherited from OOo.
Comment 7 QA Administrators 2018-09-14 02:46:00 UTC Comment hidden (obsolete)
Comment 8 Calabar 2018-09-14 08:54:04 UTC
As requested in a recent email from QA Administrators (and in the last post here), I tested again the bug with recent versions of Libreoffice. 

On libreoffice 5.4.1.2: the problem is exactly the same. 
On Libreoffice 6.1.1:   the problem is exactly the same. 

So the bug has not been solved yet. And that's highly expected, as it is still unassigned. I can understand it is a particular case and few users will notice it, but it is a clear bug and probably can be easily solved. 



Informations from "Help -> About LibreOffice":
Versione: 6.1.1.2
Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
Thread CPU: 4; SO: Windows 10.0; Resa interfaccia: predefinito; 
Versione locale: it-IT (it_IT); Calc: group threaded
Comment 9 QA Administrators 2019-09-15 02:46:39 UTC Comment hidden (obsolete)
Comment 10 Calabar 2019-09-20 12:45:30 UTC
I can confirm that the bug has not been solved yet. 
Tested with the last version of Libreoffice, v6.3.1.2 (x64) on Windows 10 1903.
Comment 11 Xisco Faulí 2019-09-20 12:56:03 UTC
(In reply to Calabar from comment #10)
> I can confirm that the bug has not been solved yet. 
> Tested with the last version of Libreoffice, v6.3.1.2 (x64) on Windows 10
> 1903.

Thanks for retesting with the latest version.
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.
Comment 12 Calabar 2019-09-20 14:09:47 UTC
(In reply to Xisco Faulí from comment #11)
> (In reply to Calabar from comment #10)
> > I can confirm that the bug has not been solved yet. 
> > Tested with the last version of Libreoffice, v6.3.1.2 (x64) on Windows 10
> > 1903.
> 
> Thanks for retesting with the latest version.
> Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been
> identified.

Hi, thanks for the answer. 
I looked at "RESOLVED WORKSFORME" definition and this case seems not to fit: the bug is clear and easily reproducible, and it seems noone fixed it somewhere. Am I missing something?
Comment 13 Terrence Enger 2019-09-28 14:34:45 UTC
I still see the bug in a local build of commit c8e2675e, 2019-09-22,
builg and running on debian-buster.

I am setting but status back to NEW.
Comment 14 QA Administrators 2022-04-27 04:01:44 UTC Comment hidden (obsolete)
Comment 15 Calabar 2022-04-29 14:13:46 UTC
As requested by an advice received by email, I confirm that the issue has not been solved still in the present versione of Libreoffice Fresh (7.3.2). 

I tried to save again the file with the up to date version of Libreoffice and reopened it (assuming that the issue could be due to something wrong written by the old version of Libreoffice in the sample file) but nothing changes.