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.
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.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
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.
@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.
Created attachment 68069 [details] ods that demonstrates that hypertext not wraps and not properly shown
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: *Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later) https://www.libreoffice.org/download/ *If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior *If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT *Update the version field *Reply via email (please reply directly on the bug tracker) *Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-04-18
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)
Still a bug, just as described in the original report. Screenshot attached.
Created attachment 116800 [details] Links not wrapping in cells
*** Bug 87957 has been marked as a duplicate of this bug. ***
*** Bug 91275 has been marked as a duplicate of this bug. ***
*** Bug 76253 has been marked as a duplicate of this bug. ***
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
Still reproducable in 5.3.0.3 (installed from RPMs provided by TDF) on Mageia 5.
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.
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?
*** Bug 118759 has been marked as a duplicate of this bug. ***
Problem still observed in Version: 6.0.6.2
Dear Anonymous Helper, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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.
*** Bug 127340 has been marked as a duplicate of this bug. ***
Reproduced in OOo 3.3 -> inherited.