Bug 148058 - Dynamic graphics enhancement: always update pivot table (and pivot chart) when source changes
Summary: Dynamic graphics enhancement: always update pivot table (and pivot chart) whe...
Status: RESOLVED DUPLICATE of bug 61793
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-03-17 17:39 UTC by Paulo
Modified: 2024-03-28 13:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
sample pivot table and pivot chart (18.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-03-28 13:07 UTC, Stéphane Guillou (stragu)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Paulo 2022-03-17 17:39:43 UTC
Description:
I have a spreadsheet in which I want to have everything automated without resorting to macros. It has a dynamic graphic which is a main spreadsheet output and I want it to update whenever I change the data in the source table. Right now I have the source table on one sheet and the dynamic table hidden and the dynamic graphic on another sheet. If I save the spreadsheet on the sheet that contains the source data table and if I update it, the dynamic graphic update, but when I visualize it, it no longer update. I only need the dynamic table to make the dynamic graphic, because then it will be hidden. So a new feature is that Calc always update the dynamic table/graphic after updating the source data table. It can be with an option in the dynamic table to update automatically and if the user don't want this situation, don't select it.

Steps to Reproduce:
1.Dynamic graphic don't update always
2.
3.

Actual Results:
The dynamic graphic only update in some cases

Expected Results:
Dynamic graphic always update 


Reproducible: Always


User Profile Reset: No



Additional Info:
Read the decription
Comment 1 Roman Kuznetsov 2022-09-18 19:27:03 UTC
What do you mean when you say "dynamic table" and "dynamic graphic"?
Comment 2 QA Administrators 2023-03-18 03:28:02 UTC Comment hidden (obsolete)
Comment 3 Paulo 2023-03-19 11:02:59 UTC
See:
Calc>Data>9 option (dynamic table)
Dynamic graphic - a graphic done from the dynamic table.
Comment 4 Stéphane Guillou (stragu) 2024-03-28 13:07:16 UTC
Created attachment 193370 [details]
sample pivot table and pivot chart

Right, you mean "Pivot Table" and "Pivot Chart".
In my test, changing the source data will not refresh the pivot table (and therefore the pivot chart) until the pivot table is refreshed. (right click > refresh)
So the request is to auto-refresh the pivot table, which is already requested in bug 61793.
Comment 5 Stéphane Guillou (stragu) 2024-03-28 13:07:54 UTC

*** This bug has been marked as a duplicate of bug 61793 ***