Bug 124766 - Exported pivot table crashes Excel when modifying years filter
Summary: Exported pivot table crashes Excel when modifying years filter
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Corrupted Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2019-04-16 08:49 UTC by Mike Kaganski
Modified: 2024-01-18 11:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
sc/qa/unit/data/xlsx/pivot-table/shared-dategroup.xlsx (17.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-04-16 08:49 UTC, Mike Kaganski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2019-04-16 08:49:22 UTC
Created attachment 150781 [details]
sc/qa/unit/data/xlsx/pivot-table/shared-dategroup.xlsx

In current master (after https://git.libreoffice.org/core/+/b082998401e37e6c7534906601bc481423a6ded0):

1. Open the attachment (out unit test document) and re-save back to XLSX;
2. Open the result in Excel 2016;
3. Clicking the drop-down button next to "a" in any of the pivot tables;
4. Apply any modification to the list (like unchecking "1965") and confirm OK.
=> Excel crashes (just disappears without error messages; next launch shows recovery panel).

Refreshing pivots in Excel before operation prevents crash.

This is not strictly a regression, since it is likely related to the new functionality (export of group fields) previously missing in LO XLSX export filter.
Comment 1 Roman Kuznetsov 2019-04-16 09:12:50 UTC
confirm for MS Excel 2010 after resave to XLSX in

Version: 6.3.0.0.alpha0+
Build ID: 3083fe569f96bf0289da1e9d0ef7da15ab22e2f6
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-04-16_01:39:55
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 2 Xisco Faulí 2019-08-07 13:23:56 UTC
Hi Mike,
Is the the same as bug 126748 ?
Comment 3 Xisco Faulí 2019-08-07 13:24:19 UTC
(In reply to Xisco Faulí from comment #2)
> Hi Mike,
> Is the the same as bug 126748 ?

same root cause*
Comment 4 Mike Kaganski 2019-08-07 13:27:52 UTC
(In reply to Xisco Faulí from comment #3)

No, the root causes are completely different. Yes, they both are related to the same commit.
Comment 5 Roman Kuznetsov 2021-02-17 11:27:56 UTC
still repro in

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 2c8ffa41ec8e1ab2af95d5e033a445c17d29cf5a
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
Comment 6 QA Administrators 2023-02-18 03:24:11 UTC Comment hidden (obsolete)
Comment 7 Gabor Kelemen (allotropia) 2024-01-18 11:58:56 UTC
Excel 2016 still crashes with file made 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