Bug Hunting Session
Bug 61793 - PIVOTTABLE: (option to) auto refresh Pivot Table after changes in source
Summary: PIVOTTABLE: (option to) auto refresh Pivot Table after changes in source
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2013-03-04 15:01 UTC by ktos.obcy+freedesktop
Modified: 2019-10-14 05:30 UTC (History)
4 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 ktos.obcy+freedesktop 2013-03-04 15:01:57 UTC
I would like to propose an additional option in Pivot table properties "Auto refresh when source selection changes" which would basically trigger refresh of Pivot Table after any changes to the cells that are within selection range upon which Pivot Table is built.
Comment 1 Joel Madero 2013-03-04 16:14:35 UTC
Sure sounds like a good idea.

Marking as 

New (valid enhancement request)
Enhancement (not a bug, additional feature)
Low (pivot tables aren't used a ton despite them being functional, this is just a way to make them slightly better as you can always refresh manually also the technical details might be a bit tough)

@anyone who takes this - maybe using the "changed" trigger - ie if a document is changed and you can save it - to cause a refresh would work.
Comment 2 ktos.obcy+freedesktop 2013-03-15 08:02:45 UTC
At the same time I've filled feature request I've started a topic on ask.libreoffice : http://ask.libreoffice.org/en/question/13770/auto-refresh-pitvot-table-after-changes-in-source/ and I've got response that... it should already work like that:

The documentation on Updating Pivot Tables ( https://help.libreoffice.org/Calc/Updating_Pivot_Tables ) says the following:

"If the data of the source sheet has been changed, LibreOffice recalculates the pivot table. To recalculate the table, choose Data -> Pivot Table -> Refresh. Do the same after you have imported an Excel pivot table into LibreOffice Calc."

There was a suggestion that I should fill a bug request so I will only link those two threads.

Curious thing - I've never noticed that pivot tables were updated automatically as per documentation.
Comment 3 Yirrell 2016-08-31 08:31:52 UTC
Any progress?
Comment 4 Heiko Tietze 2017-07-27 13:42:29 UTC
The refresh of pivot table may take a while depending on system performance and amount of data. Having a global setting to automatically refresh should include an option to override per document to cover for those situations.
Comment 5 surcouf 2018-04-27 12:35:40 UTC
(In reply to Heiko Tietze from comment #4)
> The refresh of pivot table may take a while depending on system performance
> and amount of data. Having a global setting to automatically refresh should
> include an option to override per document to cover for those situations.

Yes, it can take a while, therefore an option at pivot table level could be the proper way. There are already 6 options like "ignore empty lines", "Enable drill to details" etc... 
I propose a 7th option "REFRESH DATA at FILE OPENING". 
With this option, everyone is responsible of his own performance, this is not LibreOffice Calc responsibility.
Comment 6 cpohle 2018-12-03 16:19:50 UTC
(In reply to Heiko Tietze from comment #4)
> The refresh of pivot table may take a while depending on system performance
> and amount of data. Having a global setting to automatically refresh should
> include an option to override per document to cover for those situations.

I agree, automatically recalculating after every change of a source table might takte too long and disturb the workflow. In cases where the data source is a SQL query, auto-update wouldn't be possible at all.

However, providing a visual clue when a data source change could/has been detected would significantly improve usability and help in avoiding errors. Think e. g. some icon in the pivot tables top-left corner.