Apache OpenOffice (AOO) Bugzilla – Issue 13807
Text in cells doesn't wrap for a hyperlink
Last modified: 2013-02-07 22:32:28 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.
Hi, 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. Frank *** This issue has been marked as a duplicate of 13637 ***
closed
> 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 hyperlink).
Hi, 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 Frank *** This issue has been marked as a duplicate of 13637 ***
closed duplicate
> 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 TRUNCATED! Thanks.
Hi, 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 Frank
> 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?
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 ? :)
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).
*** Issue 62060 has been marked as a duplicate of this issue. ***
*** Issue 84100 has been marked as a duplicate of this issue. ***
Hyperlinks should wrap to the next line like normal text. (I just wanted to file an issue therefor but found this one.)
Still broken in OOo 3.0.
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
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? THIS IS NOT AN ENHANCEMENT: THIS IS A BUG. 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?
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.