Get wrapped version of hyperlinked text?

I am a new LibreOffice user, using version 6.4.03 (x64) on Windows 10.

I imported an Excel file in which a column consists entirely of hyperlinked text (small sample of content attached). The text does not wrap, making the document virtually useless to me. I saved it as an *.ods file and explicitly applied wrapping, but no joy.

The solution at https://bugs.documentfoundation.org/show_bug.cgi?id=39910 says to use the =hyperlink() function. That’s fine for newly created content, but I’m looking a large number of pre-existing cells.

Is there a quick way to get the display text to wrap?

test.ods

There may be formatting on the cells from Excel. Transitions from MS Office to LibreOffice are often troubled by the difference in style handling and formatting between the suites, so remove “inherited” formatting first.

  • Select the offending column and then menu item Format - Clear direct formatting (ctrl+M). Hopefully this doesn’t ruin the linking.

Apply text wrap again.

  • I assume that you used the wrap setting from Format - Cells, tab Alignment.

I thought this worked, but didn’t properly check. I seemed to work, but unfortunately, it also removed the hyperlink.

If you selected the column when you applied the above, “almost solution”, it indicates that the formatting issue is connected to that column only.

… unfortunately, it also removed the hyperlink.

Then we need to remove the part of formatting which clutters wrapping, instead of the “clear all” shotgun approach. One likely candidate is hard formatted row heigth.

  • Select the column.
  • Menu item Format - Rows - Optimal heigth.

If the row heigth guess is also wrong, you could perhaps attach a file which displays the issue. A few rows will do.

Guessing is not so efficient with this kind of problem. Hands on is better.

The row height doesn’t seem to be the problem, because some rows are actually quite high due to non-hyperlink content in other columns. However, I selected the column of hyperlinks and set the row height to optimal, as you described. No luck. I attached a sample of the hyperlink content to the original question. Thanks.