Bug 148058

Summary:	Dynamic graphics enhancement: always update pivot table (and pivot chart) when source changes
Product:	LibreOffice	Reporter:	Paulo <promualdom>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	enhancement	CC:	79045_79045, stephane.guillou
Priority:	medium
Version:	7.3.1.3 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	sample pivot table and pivot chart

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)

Dear Paulo,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping

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 ***