[Libreoffice-bugs] [Bug 139274] New: Related to LibreOffice Calc: Hyperlinks in cells with text saved in Excel format, error after re-opening of file

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139274

            Bug ID: 139274
           Summary: Related to LibreOffice Calc: Hyperlinks in cells with
                    text saved in Excel format, error after re-opening of
                    file
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: volker.stroenisch at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201228/83fbab38/attachment.htm>