Bug 162127 - When duplicating a pivot-table+chart sheet, chart is linked to original
Summary: When duplicating a pivot-table+chart sheet, chart is linked to original
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart Pivot-Table Pivot-Chart
  Show dependency treegraph
 
Reported: 2024-07-21 08:07 UTC by Eyal Rozenberg
Modified: 2024-07-24 06:41 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2024-07-21 08:07:12 UTC
(split off from bug 161913)

Reproduction instructions:

1. Create a document with data in one sheet, and a pivot-table + pivot-chart in another sheet; or open attachment 195119 [details]
2. Right-click the pivot-table+chart sheet, and duplicate it
3. Save the file and close it
4. Reopen the file
5. On the original pivot-table sheet, use the drop-down filter on the Status column and de-select Resolved
6. Compare the charts on the original pivot-table+chart sheet and on the duplicated one

Expected results:
Charts are different - the first has no "RESOLVED" item (e.g. in the legend), the second has it.

Actual results:
Charts are identical - both are missing "RESOLVED"

So, the duplicated sheet's chart is linked to the original sheet's pivot-table rather than its own sheet's. Changing the new sheet's pivot-table (e.g. by filtering) has no effect.

Note that steps 3 and 4 are a workaround for bug 161913.
Comment 1 raal 2024-07-21 09:00:06 UTC
Confirming.
Comment 2 raal 2024-07-21 09:08:44 UTC
When I duplicate sheet with Pivot chart and change filter, LO crashes. I suppose that solving this bug will solve also the crash. 
Steps:
- Create a document with data in one sheet, and a pivot-table + pivot-chart in another sheet; or open attachment 195119 [details] 
- Right-click the pivot-table+chart sheet, and duplicate it 
- On the new sheet click on Status filter in the Pivot table, deselect All and select one or more items.
- Click OK.
- Crash.
Comment 3 Eyal Rozenberg 2024-07-21 09:46:16 UTC
Build id:

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-IL (en_IL); UI: en-US
Calc: threaded
Comment 4 Eyal Rozenberg 2024-07-21 09:47:44 UTC
(In reply to raal from comment #2)

I don't get the crash... it seems to work for me. Perhaps file it as a separate bug?
Comment 5 m_a_riosv 2024-07-22 00:29:52 UTC
This is not the same issue as tdf#161913?
Comment 6 Eyal Rozenberg 2024-07-22 07:07:48 UTC
(In reply to m_a_riosv from comment #5)
> This is not the same issue as tdf#161913?

No: Bug 161913 one is about an initial painting of the chart not occurring - regardless of which table's data it looks at.