Description:
the problem occurs under following conditions (repeatedly):
- a text is entered in a cell plus a hyperlink. After saving the file in Excel-format and re-opening the file, the respective cell in the file is damaged: formatting is destroyed, everything appears as one line and is seen as the hyperlink, the line can not be edited any longer in a regular way.

Steps to Reproduce:
The problem occurs under following conditions (repeatedly):
1. a text is entered in a cell
2. the text is followed by a hyperlink (either a URL inserted directly with the option "URL automatically detected" or a hyperlink itself)
3. first the cell looks ok and can further be edited etc.

4) now: save the file in Excel-format (xls or xlsx) and re-open it:
5) the format of the respective cell is destroyed. The whole cell with the whole text is seen as the hyperlink. Editing of the cell is no longer possible

As workaround the hyperlink itself can be deleted
2.
3.

Actual Results:
the cell with containing the hyperlink is damaged. the formatting like enforcd line breaks is gone, everything is shown in one line and the cell can not be editied any longer in a normal way.

By the way: opening the file in Microsoft Excel shows correct results!

Expected Results:
The cell should look like before re-opening.
It seems to me like a problem with the excel-format in saving and restoring of the file


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded