Bug 122476 - FILEOPEN XLSX, Pivot table with extendable line gets distorted and its pivot diagram messed up
Summary: FILEOPEN XLSX, Pivot table with extendable line gets distorted and its pivot ...
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 11:14 UTC by NISZ LibreOffice Team
Modified: 2024-01-18 11:52 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
The original spreadsheet. (25.08 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 11:15 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (305.69 KB, image/png)
2019-01-04 11:15 UTC, NISZ LibreOffice Team
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 11:14:22 UTC
Description:
When the attached document gets opened in LO the extendable lines appear in a different column thus messing up the diagrams functions and when they get retracted/extended the functions dont change dinamically unlike it does in LO. Also a new line appears before the pivot table further messing with the diagram.

Steps to Reproduce:
    1. Open the attached document in LO and MSO.
    2. Notice the differences and try retractin extending the lines by double clicking.

Actual Results:
The diagram uses different data points and changes when the linse get retracted or extended.

Expected Results:
It should behave the same as in MSO.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 11:15:15 UTC
Created attachment 148021 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2019-01-04 11:15:36 UTC
Created attachment 148022 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2019-01-04 21:04:23 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 17:39:21 UTC
Same behaviour 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
Comment 5 Buovjaga 2019-01-26 15:24:45 UTC
Confirmed.

Win 10
3.3.0
Comment 6 QA Administrators 2021-01-26 05:12:25 UTC Comment hidden (obsolete)
Comment 7 NISZ LibreOffice Team 2021-01-26 09:04:36 UTC
Still the same in:

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 6c8a6b6aa2f962bd2fadbdf27405bfcd7d167fec
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Comment 8 QA Administrators 2023-01-27 03:25:25 UTC Comment hidden (obsolete)
Comment 9 Gabor Kelemen (allotropia) 2024-01-18 11:52:34 UTC
Still quite bad in

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 25276df12abd9d002f7f899900434617b256f745
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (hu_HU); UI: en-US
Calc: threaded