Bug 39910 - Text-Wrapping Doesn't Wrap Long HyperLinks Resulting in Cutoff Text
Summary: Text-Wrapping Doesn't Wrap Long HyperLinks Resulting in Cutoff Text
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 76253 87957 91275 118759 127340 (view as bug list)
Depends on:
Blocks: Anchor-and-Text-Wrap Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2011-08-07 13:40 UTC by Anonymous Helper
Modified: 2024-07-24 14:24 UTC (History)
11 users (show)

See Also:
Crash report or crash signature:


Attachments
ods that demonstrates that hypertext not wraps and not properly shown (12.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-10-04 09:07 UTC, sasha.libreoffice
Details
Links not wrapping in cells (251.34 KB, image/png)
2015-06-24 14:07 UTC, samtuke
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Anonymous Helper 2011-08-07 13:40:57 UTC
Put the following URL in a cell:
http://www.hmrc.gov.uk/rates/nic.htm

Most of the text is not visible because the cell is not wide enough.
When there is nothing in the cell to the right, the text should spill over.
Resizing the column is not an option since the rest of the column is much smaller and this is an anomaly.

If you don't want to implement this as a default, it should be implemented as an option since this is what Excel users have come to expect as the behaviour.
Comment 1 Anonymous Helper 2011-08-07 13:54:41 UTC
Re-saving the file to xls and opening in Excel immediately showed (in the ribbon) that Wrap Text was on the cell.
Turning this off, saving the file and opening it in Calc showed it flowing again.

After 15minutes of searching the menus and toolbar buttons (no tooltips!) I still can't see how to achieve this in Calc.
Comment 2 Björn Michaelsen 2011-12-23 12:25:50 UTC Comment hidden (obsolete)
Comment 3 Florian Reisinger 2012-08-14 14:01:21 UTC Comment hidden (obsolete)
Comment 4 Florian Reisinger 2012-08-14 14:02:26 UTC Comment hidden (obsolete)
Comment 5 Florian Reisinger 2012-08-14 14:07:03 UTC Comment hidden (obsolete)
Comment 6 Florian Reisinger 2012-08-14 14:09:07 UTC Comment hidden (obsolete)
Comment 7 sasha.libreoffice 2012-10-01 13:35:08 UTC
Reproduced in 3.6.1 on Fedora 64 bit
Problem is: LO never wraps internet-links. Not only Calc, but other modules too. As result, all documents with long links from msOffice looks different in LO.
I do not know if it is bug or feature.

PS: double click described in Bug 39909 here in with link not works too.
Comment 8 Joel Madero 2012-10-03 17:27:28 UTC
@Anonymous Helper: Sasha has gotten the gist of I think your problem. Do you have text-wrapping enabled on the cell with the link? If the text-wrapping is not on, then there is no problem, the overflow works and you can see the full link. If on the other hand you have text wrapping on, LibO is designed to cut off whatever is wider than the cell. 

I'm going to (for the time being) confirm that the text wrapping should act differently for long links. Also changing the name of the bug to reflect this.

If this isn't the case please leave a comment and attach a document so I can see what your settings are. I highly suspect that Sasha got this one right and it's a text wrap issue and not a spillover issue.
Comment 9 sasha.libreoffice 2012-10-04 09:07:35 UTC
Created attachment 68069 [details]
ods that demonstrates that hypertext not wraps and not properly shown
Comment 10 QA Administrators 2015-04-19 03:20:09 UTC Comment hidden (obsolete)
Comment 11 Buovjaga 2015-06-15 10:18:41 UTC
Link still cut off, if wrapping enabled in cell.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 01a189abcd9a4ca472a74b3b2c000c9338fc2c91
TinderBox: Win-x86@39, Branch:master, Time: 2015-06-14_07:46:28
Locale: fi-FI (fi_FI)
Comment 12 samtuke 2015-06-24 14:06:59 UTC
Still a bug, just as described in the original report. Screenshot attached.
Comment 13 samtuke 2015-06-24 14:07:48 UTC
Created attachment 116800 [details]
Links not wrapping in cells
Comment 14 Buovjaga 2015-10-16 19:25:19 UTC
*** Bug 87957 has been marked as a duplicate of this bug. ***
Comment 15 Buovjaga 2015-10-16 19:26:16 UTC
*** Bug 91275 has been marked as a duplicate of this bug. ***
Comment 16 Buovjaga 2015-10-16 19:27:22 UTC
*** Bug 76253 has been marked as a duplicate of this bug. ***
Comment 17 QA Administrators 2017-01-03 19:35:23 UTC Comment hidden (obsolete)
Comment 18 Mihkel Tõnnov 2017-02-18 21:25:01 UTC
Still reproducable in 5.3.0.3 (installed from RPMs provided by TDF) on Mageia 5.
Comment 19 brucehohl 2017-02-19 00:31:12 UTC
Until this gets attention a work around is to use the =hyperlink() formula instead of Insert > Hyperlink (Ctrl+K).  In hyperlink() the URL can also be used as the CellText if desired.  Regardless of what is used as the CellText wrapping will work.  And, you choose your own background and font colors, if desired.
Comment 20 Wolfgang Jäger 2018-03-10 13:53:03 UTC
Tested with V6.0.2.1 today (2018-03-10). Behaviour unchanged.  

A few additional remarks: 

Text portions being differently formatted (bold, italic e.g.) are wrapped as expexted. URL textfields are not. These different kinds of text portions are also differently treated when text is edited under F2: Neither in the formula bar nor in the cell area URL are editable on the character level then. Concerning cursor movements an URL is treated as ONE character in this case.
 
(!)At the same time the URL is editabel in the formula bar if the cell got the focus by a mouse click. (Additional surprises.) 

Moving the focus to the cell using the cursor keys reults in the 
as-if-one-character beahviour. 

There is more than one inconsistency!

(heritage) The behaviour originally reported is inherited from OOo as I just tested with LibO V3.3.0 (portable) and also with AOO V4.1.5. 

The inconsistency marked "(!)" above did not show in the tests marked "(heritage)". 

Were there changes made intentionally? If so everybody knowing the facts is kindly invited to reort here. 

Is there a stringent reasons to handle URL textfields differently when calculating for wrapping?
Comment 21 Buovjaga 2018-08-24 16:32:34 UTC
*** Bug 118759 has been marked as a duplicate of this bug. ***
Comment 22 Ronny 2018-11-20 18:34:33 UTC
Problem still observed in Version: 6.0.6.2
Comment 23 QA Administrators 2021-08-28 03:53:03 UTC Comment hidden (obsolete)
Comment 24 Wolfgang Jäger 2021-08-28 14:35:14 UTC
The descrobed bahavior is unchanged in V 7.2.0.4 

Putting the (reported) different bahavior of any Excel aside, this isn't clearly an issue. I would assume the behavior was originally intended, and a change might even break some sheets by unneeded increases to rowheights. 

Anyway, this VERY old bug should either be fixed regarding compatibility aspects, or set WONTFIX after 10 years of pending. (The see-also-bugs are of comparable age.(

The background surely is that hyperlinks in spreadsheet cells are implemented as textfields. This is basically dfferent from the way hyperlinks are treated by Writer where the hyperlinks are attributed text portions and can therefore simply take part in the general textflow.
Comment 25 Aron Budea 2023-02-22 19:25:54 UTC
*** Bug 127340 has been marked as a duplicate of this bug. ***
Comment 26 Stéphane Guillou (stragu) 2024-04-16 14:23:24 UTC
Reproduced in OOo 3.3 -> inherited.
Comment 27 Yellbanoid 2024-05-31 10:55:26 UTC
I really want to thank the developers for having resolved a lot of bugs already, and encourage them to continue with this hyperlink-wrapping-problem.