Issue 13807 - Text in cells doesn't wrap for a hyperlink
Summary: Text in cells doesn't wrap for a hyperlink
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 644
Hardware: All All
: P4 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 62060 84100 (view as issue list)
Depends on:
Reported: 2003-04-25 12:12 UTC by bkline
Modified: 2013-02-07 22:32 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description bkline 2003-04-25 12:12:11 UTC
How to repeat:

 1. Create a new OOo spreadsheet.
 2. Open the Insert menu.
 3. Select Hyperlink.
 4. Fill in the target and text fields, with a long text value (more than
    will fit in the cell on one line).
 5. Click Apply and Close.
 6. Open the Format menu.
 7. Select Cells.
 8. Check the "Automatic line break" property.
 9. Click OK.

At least it doesn't bleed into adjacent text cells to the right, as earlier
versions of OOo did.
Comment 1 frank 2003-04-25 13:15:13 UTC

what's about using the find Issue link and placing hyperlink in the
summary field and Spreadsheet in the component field. This would bring
Issue 13637 which is now a double to this one.


*** This issue has been marked as a duplicate of 13637 ***
Comment 2 frank 2003-04-25 13:17:59 UTC
Comment 3 bkline 2003-04-25 13:56:48 UTC
> what's about using the find Issue link and placing hyperlink in 
> the summary field and Spreadsheet in the component field.

First of all, I did a search on "wrap" and "hyperlink" (as well as
some other combinations) and no issues were found.  It's always easy
to complain that the submitter didn't look for the right keywords for
an existing issue when you already know about the issue, but not
always as easy to guess the right combinations when you don't (and
when you're not as familiar with the issue database as the developers).

Second of all, the issue you say is a duplicate of this is marked as
"fixed" when in fact the description says that the developer couldn't
reproduce the behavior (I was under the impression that Bugzilla used
WORKSFORME for this situation, rather than FIXED).

Third, I can reproduce the behavior consistently, and I provided
instructions for doing so.

Finally, and most relevant, my report was not for the same behvior as
issue 13637, which said "the entire text is seen."  If you read my
report again, you'll see that the behavior I described was that the
text does *not* wrap nor bleed into the adjacent cells; in other
words, the entire text is *not* seen, but should be (because the word
wrap triggered by the "Automatic line break" property should cause the
entire text content of the cell to be visible, as is true for text
content of a cell with this property when the text is not part of a
Comment 4 frank 2003-04-25 14:32:50 UTC

first of all, I'm not a developer.

second, to use simple search strings as the first approach should be
used and not a combination of some strings.

third, this is indeed a double to the mentioned Issue. Hyperlinks
can't be treated with a line break. The submitter of the mentioned bug
had the same problem and some more.

I've checked this under OOo1.0.3 and OOo1.1beta on the 1.1beta the
behaviour with the overflow into the next cell if linebreak was
selected is fixed. So this Issue is fixed and not worksforme.

So I've to close this one as double.

Best regards


*** This issue has been marked as a duplicate of 13637 ***
Comment 5 frank 2003-04-25 14:33:08 UTC
closed duplicate
Comment 6 bkline 2003-04-25 14:56:21 UTC
> Hyperlinks can't be treated with a line break.

Why not?  I don't see any indication that this is true in the
documentation I have read for hyperlinks or for automatic line breaks
in the OOo documentation.  I don't see any indication on the cell
formatting dialog box that the automatic line break property isn't
going to do what it says it's going to do.  This works properly in
Excel.  Why can't it work the way the documentation says it will work
in OOo?

I don't expect that a URL will be word wrapped, but we're not talking
about the URL, are we?

> ... this is indeed a double to the mentioned Issue ...

I'm sorry, but at the risk of sounding rude, could I ask you to
actually go back and read the two issues?  The reporter for issue
13637 says that the entire text for the cell is being displayed.  The
problem I am reporting is that THE DISPLAY TEXT FOR THE CELL IS BEING

Comment 7 frank 2003-04-25 16:19:21 UTC

Hyperlinks can't get a linebreak, as they are treated as block by the
edit engine. So this works as intended in OOo1.1beta resulting in the
duplicate Issue I've mentioned before. 

But it could be an enhancement request. So I set the flags and forward
it to the decissions team.

Hi Bettina,

1 4 u

Comment 8 bkline 2003-04-25 19:20:52 UTC
> Hyperlinks can't get a linebreak, as they are treated as block
> by the edit engine. So this works as intended ....

I'm sorry, but I've taken the trouble to point out the parts of the
OOo documentation and user interface that lead me to believe that the
software should behave the way Excel does here.  Could you direct me
to the part of the documentation that I've missed that supports what
you're saying?

If there isn't such documentation, then why isn't it a bug instead of
an enhancement if the software doesn't behave the way the
documentation leads you to believe it will?
Comment 9 richlv 2005-02-15 10:08:00 UTC
hyperlinks also don't break when inserted in an impress presentation.

in some cases this leads to completely different layout when a ppt is imported 
in impress.

this issue is filed against spreadsheet, but as i understand it's more or less 
about the same thing - unability to break hyperlinks.

should i file another issue or just vote for this ? :)
Comment 10 bkline 2005-10-21 17:01:33 UTC
Is there no one on the oocalc team who is capable of understanding the
difference between "breaking a hyperlink" and wrapping the displayed text in a
cell which contains a hyperlink?  The displayed text is not the hyperlink or its
URL.  It makes perfectly good sense to refuse to break the URL.  But the URL is
not what is displayed in the cell.  What's so hard about this concept?

The version field is read-only for this issue, but the bug is still present in
the 2.0 release (all platforms).
Comment 11 frank 2006-02-16 11:55:43 UTC
*** Issue 62060 has been marked as a duplicate of this issue. ***
Comment 12 frank 2007-11-30 17:51:02 UTC
*** Issue 84100 has been marked as a duplicate of this issue. ***
Comment 13 norbert2 2008-11-17 10:16:08 UTC
Hyperlinks should wrap to the next line like normal text. (I just wanted to file
an issue therefor but found this one.)
Comment 14 bkline 2008-12-24 18:50:45 UTC
Still broken in OOo 3.0.
Comment 15 bettina.haberer 2010-05-21 14:42:49 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 16 leontheremin 2010-10-14 00:40:12 UTC
I can't believe that in 7 (SEVEN) years, no one can figure out how to wrap the
anchor text of an HREF.  That's 7 YEARS.  I have run into this problem and tried
everything I can think of to work around it, but it is so fundamentally broken
that it is impossible.  What is also odd is that "Insert --> Hyperlink" results
in something different than "=HYPERLINK($TARGET;$ANCHOR)" (which I have found
even more worthless than "Insert --> Hyperlink").  What is wrong with honoring
the "Cell Format --> Automatic Line Break" attribute?  Why are there two
distinct ways to enter a hyperlink and two presentations of them?


As a software engineer, I get the sense just from the "Insert --> Hyperlink"
dialog box that it is an afterthought mis-feature.  What is the purpose of
separate "Apply" and "Close Buttons"?  This dialog box is suspect because it
appears to be hand crafted and unlike the rest of the Calc style.

Finally, who is "fst" and where is the source of his magical proclamations like
"Hyperlinks can't be treated with a line break?"  Where does that come from? 
Does he know the difference between the HREF link target and the anchor text? 
Or is he, like so many other non-developers on all the open source "support
fora" just making stuff up as he goes along because he wants to sound all smart
and stuff?

Could somebody (who actually knows something) please cite why (a) there is an
international standard that precludes line breaks in anchor text, or (b) a
compatibility issue with something that does not suck, or (c) it is such an
immensely tough coding issue that a rookie can't fix it.  Just kicking the can
down the street is what makes Open Source suck: many eyes can find all the bugs
but who cares if nobody can be bothered to fix the bugs? 

Is there anybody listening?
Comment 17 leontheremin 2010-10-16 20:07:04 UTC
Additional note: if the "Automatic Line Break" attribute is cleared, a small,
red triangle appears on the right side of the cell with a hyperlink with an
anchor text longer than the cell (but not if the text is shorter than the cell).
 If the "Automatic Line Break" attribute is set, the small red triangle
disappears.  But of course, there is no effect on the text displayed.  I had to
go to 250% zoom to clearly view the red triangle.  So something in the rendering
code knows what should and should not be happening.  It's just that the
rendering code for the anchor IS BROKEN.  It's just not that hard to understand.