[Libreoffice-bugs] [Bug 140496] New: EOL character is not processed correctly when opening xlsx-files with cells containing multi-line text and hyperlinks

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140496
           Summary: EOL character is not processed correctly when opening
                    xlsx-files with cells containing multi-line text and
                    hyperlinks
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sergey_nemna at yahoo.co.uk

Description:
The combination «hyperlink + EOL + text» in a Calc cell can't be read correctly
if stored in xlsx-format.

Steps to Reproduce:
1. Launch Calc and enter two lines of text (use Ctrl-Enter to insert EOL
character) in a cell.
2. Select the first line, hit Ctrl-K.
3. Provide arbitrary valid destination for the hyperlink, click «OK».
4. Save the file in the ods format.
5. Save the file in the xlsx format.
6. Relaunch Calc and open both saved files.

Actual Results:
The cell in the ods-file looks exactly as did before saving. Text of the same
cell in the xlsx-file goes in one line, i. e. the EOL character has not been
recognised properly. Please see examples of such files and screen-shot
depicting the problem visually attached.

Expected Results:
The xlsx-file should look as its ods counterpart does.


Reproducible: Always


User Profile Reset: No



Additional Info:
The xlsx-file looks as expected when opened in MS Excel. So, it looks like the
export to xlsx works nominally. Apparently, the problem occurs when the file is
being opened in Calc.

-- 
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/20210218/0b0fe748/attachment.htm>