Bug 129190 - PIVOT CHARTS do not survive round-trip with flat ODS
Summary: PIVOT CHARTS do not survive round-trip with flat ODS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Keywords: dataLoss, filter:ods
Depends on:
Blocks: Pivot-Chart ODF-Flat
  Show dependency treegraph
Reported: 2019-12-04 19:06 UTC by Kohei Yoshida
Modified: 2023-04-08 07:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

test ODS to save as FODS (21.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-04-08 07:14 UTC, Stéphane Guillou (stragu)

Note You need to log in before you can comment on or make changes to this bug.
Description Kohei Yoshida 2019-12-04 19:06:52 UTC
Pivot charts become regular charts after saving the document as a Flat ODS file and reloading it.  Saving the same document as a regular ODS file and reloading it works fine.

Steps to Reproduce:
1. Create a pivot table.
2. Create a pivot chart from the pivot table you just created.
3. Save the document in Flat ODS format.
4. Reload the file.

Actual Results:
The chart becomes a regular chart with internal data table.

Expected Results:
The chart remains a pivot chart still maintaining a link to the pivot table.

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Oliver Brinzing 2019-12-05 17:31:38 UTC
confirming with:

Version: (x64)
Build ID: 00262b08984fb2fb91b760d588851bd47ae4d3ac
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded

> The chart becomes a regular chart with internal data table.

if one tries to edit the data range:

"This chart currently contains an internal data table. Do you want to proceed, deleting the internal data table, and set a new data range?"
Comment 2 flywire 2020-04-10 11:16:06 UTC
Confirming both as above.

Version: (x64)
Build ID: 4d224e95b98b138af42a64d84056446d09082932
CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: en-AU (en_AU); UI-Language: en-GB
Calc: threaded
Comment 3 QA Administrators 2022-04-11 03:31:15 UTC Comment hidden (obsolete)
Comment 4 Stéphane Guillou (stragu) 2023-04-08 07:14:21 UTC
Created attachment 186541 [details]
test ODS to save as FODS

Still reproducible in a recent master build:

Version: (X86_64) / LibreOffice Community
Build ID: 23bd3bd10e74b0c23c2654d02d7d830e7693adac
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded