Bug 122463 - FILEOPEN XLSX, Word wrap is lost from pivot table labels in LO.
Summary: FILEOPEN XLSX, Word wrap is lost from pivot table labels in LO.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2019-01-04 09:28 UTC by NISZ LibreOffice Team
Modified: 2024-04-16 12:16 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
The original spreadsheet. (1.01 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 09:29 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (319.80 KB, image/png)
2019-01-04 09:29 UTC, NISZ LibreOffice Team
Details
The example document in Excel and Calc master (96.28 KB, image/png)
2024-04-15 09:02 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-01-04 09:28:37 UTC
Description:
When the attached file gets opened in LO the word wrap is gone form the pivot table’s labels on page 1.

Steps to Reproduce:
    1. Open the attached file in LO and MSO.
    2. Notice the differences.

Actual Results:
The labels are not word wrapped in LO.

Expected Results:
They should be as they are in MSO.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 09:29:13 UTC
Created attachment 147995 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2019-01-04 09:29:34 UTC
Created attachment 147996 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2019-01-04 18:41:11 UTC
Thank you for reporting the bug. I can confirm that the bug is present in

Version: 6.3.0.0.alpha0+
Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 4 Xisco Faulí 2019-01-16 18:54:17 UTC
Also reproduced in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 5 Buovjaga 2019-01-27 16:02:32 UTC
Confirmed in 3.3.0 on Win 10
Comment 6 QA Administrators 2021-01-27 04:28:12 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2023-01-28 03:25:17 UTC Comment hidden (obsolete)
Comment 8 Michaela 2023-08-30 18:40:19 UTC
Still repro with:
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: e46e663cc350d89e4997095466d675b875eb2e04
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Comment 9 Gabor Kelemen (allotropia) 2024-04-15 09:02:08 UTC
Created attachment 193680 [details]
The example document in Excel and Calc master

Pivot table seems to be missing in current master:

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d76f1877f699c91f5e4a020641c6d65064bfb997
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default

supposedly after recent patches to improve XLSX-pivot import.
Comment 10 Gabor Kelemen (allotropia) 2024-04-15 09:03:33 UTC
@Tomaz can you take a look?

also it did not finish opening when the same file was already open in Excel and Calc tried to open it RO.
Comment 11 Tomaz Vajngerl 2024-04-15 14:24:46 UTC
In the dev build it crashes for me, so this is the reason it is missing. I'll look...
Comment 12 Tomaz Vajngerl 2024-04-16 12:16:54 UTC
https://gerrit.libreoffice.org/c/core/+/166138 should fix the crash at least