Bug 132886 - Pivot table refresh does not work
Summary: Pivot table refresh does not work
Status: REOPENED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2020-05-09 18:48 UTC by Stephen Zvacek
Modified: 2020-08-26 06:45 UTC (History)
1 user (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 Stephen Zvacek 2020-05-09 18:48:49 UTC
Description:
I have a main table and three pivot tables that sort data from the main table.  After adding new data to the main table, I select the applicable pivot to update.  I select pivot table-refresh.  The data in the pivot table does not refresh.  I have selected "edit" and then saved and then tried to refresh but get the same result. 

Steps to Reproduce:
1. main table and three pivot tables.
2. Add new data to the main table
3. Save updated main table
4. Select applicable pivot table
5. Select Pivot table-refresh


Actual Results:
The pivot table does not refresh

Expected Results:
Table should refresh with new data


Reproducible: Always


User Profile Reset: No



Additional Info:
To get the pivot table to update with the new data, I have to delete the pivot table and recreate the same table
Comment 1 Oliver Brinzing 2020-05-10 06:44:45 UTC
Thank you for reporting the bug. 

To be certain the reported issue is not
related to corruption in the user profile, could you please reset your
Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and
re-test?

If the problem persists, please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

you may aslo have a look at:
Bug 123638 - Pivot Refresh to be included in the Recalculate Hard(CTRL+SHIFT+F9)
Bug 61793 - PIVOTTABLE: (option to) auto refresh Pivot Table after changes in source

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 Stephen Zvacek 2020-05-11 16:14:05 UTC
The pivot tables refresh properly when in "Safe" mode.