Bug 140496 - EOL character is not processed correctly when opening xlsx-files with cells containing multi-line text and hyperlinks
Summary: EOL character is not processed correctly when opening xlsx-files with cells c...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Limitations
  Show dependency treegraph
 
Reported: 2021-02-18 08:33 UTC by Sergey Nemna
Modified: 2023-05-13 12:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
The screen-shot (116.17 KB, image/png)
2021-02-18 08:35 UTC, Sergey Nemna
Details
This fille looks correct when opened (9.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-02-18 08:36 UTC, Sergey Nemna
Details
This fille looks wrong when opened (7.91 KB, application/zip)
2021-02-18 08:37 UTC, Sergey Nemna
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sergey Nemna 2021-02-18 08:33:28 UTC
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.
Comment 1 Sergey Nemna 2021-02-18 08:35:07 UTC
Created attachment 169845 [details]
The screen-shot
Comment 2 Sergey Nemna 2021-02-18 08:36:18 UTC
Created attachment 169846 [details]
This fille looks correct when opened
Comment 3 Sergey Nemna 2021-02-18 08:37:00 UTC
Created attachment 169847 [details]
This fille looks wrong when opened
Comment 4 m_a_riosv 2021-02-18 19:12:22 UTC
Confirmed
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 44b914b1e2616ca8f70e896e653a46ca93610234
CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 5 QA Administrators 2023-02-19 03:20:09 UTC Comment hidden (obsolete)
Comment 6 Sergey Nemna 2023-02-26 14:21:32 UTC
The bug was re-tested. It still exists in the following configurations:

Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_US); UI: en-GB
Calc: threaded

Version: 7.4.5.1 / LibreOffice Community
Build ID: 40(Build:1)
CPU threads: 4; OS: Linux 5.17; UI render: default; VCL: qt5 (qfont+xcb)
Locale: ru-RU (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.4.5-0ubuntu0.20.04.1~lo1
Calc: threaded