Bug 122472 - FILEOPEN XLSX, Pivot table’s cells lose all their formatting in LO
Summary: FILEOPEN XLSX, Pivot table’s cells lose all their formatting 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 xlsx-aggressive-competitors
  Show dependency treegraph
 
Reported: 2019-01-04 10:32 UTC by NISZ LibreOffice Team
Modified: 2024-07-22 13:14 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
An xlsx with a pivot table with formatted cells. (18.71 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 10:32 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (346.07 KB, image/png)
2019-01-04 10:33 UTC, NISZ LibreOffice Team
Details
another sample where the borders are incorrect (21.01 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-10-25 10:18 UTC, Xisco Faulí
Details
Screenshot of the example file in Excel 2016 and Calc master (120.64 KB, image/png)
2024-04-15 10:37 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 10:32:01 UTC
Description:
When a xlsx with a pivot table is opened in LO all of the pivot table’s cells lose their formatting and revert back to the default cell format.

Steps to Reproduce:
    1. Create a new xlsx in Excel and create a pivot table withs some data.
    2. Give some of the cells formatting.
    3. Save the file.
    4. Open it in Calc.

Actual Results:
All of the cells in the pivot table. lose their formatting.

Expected Results:
They should keep all of their formatting even those that were given automatically by Excel.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 10:32:34 UTC
Created attachment 148013 [details]
An xlsx with a pivot table with formatted cells.
Comment 2 NISZ LibreOffice Team 2019-01-04 10:33:21 UTC
Created attachment 148014 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2019-01-04 19:15:21 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-08 15:29:18 UTC
Also reproduced in

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default; 

Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 5 Xisco Faulí 2019-01-16 17:44:16 UTC
Also reproduced in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 6 Buovjaga 2019-01-26 15:27:36 UTC
Confirmed.

Win 10
3.3.0
Comment 7 Xisco Faulí 2019-10-25 10:18:36 UTC
Created attachment 155302 [details]
another sample where the borders are incorrect
Comment 8 Justin L 2022-10-24 22:53:46 UTC
repro 7.5+. Also lost on a file round-tripped by Excel 2003.
Comment 9 Emre 2023-09-22 05:26:15 UTC
Confirmed on 7.6.1 and this is the single thing holding me to use libreoffice exclusively.
Comment 10 Gabor Kelemen (allotropia) 2024-04-15 10:37:36 UTC
Created attachment 193685 [details]
Screenshot of the example file in Excel 2016 and Calc master

Still happens in 

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

after recent patches to improve xlsx cell formatting import.