I'm having trouble with the format of the cell in Calc after adding a hyperlink to it. See the attached files "Excel sample.xlsx and the Calc sample.ods to see what I mean. In Excel, I would have the long text change to the next line within the cell to fit the size of the cell and add a hyperlink to it and it appears OK, but when I want to do the same in Calc or save the Excel file as a Calc .ods file, the long text will not change to the next line after adding the hyperlink to it (even after using Ctrl Enter or Shift Enter). Can someone help me to to solve this problem. Thanks!

Excel sample.xlsx

Calc sample.ods

edit retag close merge delete

A really hacky workaround is this: Assuming you want to display a hyperlink with linebreaks in cell A1, then enter the link text in some other cell, say B1 (but could also be in another worksheet, obviously), and then in cell A1 enter =HYPERLINK("https://libreoffice.org",B1).