Bug 108235 - Pivot table update on undo lags a step behind
Summary: Pivot table update on undo lags a step behind
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks: Pivot-Table Undo-Redo
  Show dependency treegraph
 
Reported: 2017-05-30 05:16 UTC by Aron Budea
Modified: 2023-04-03 08:50 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample (21.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-30 05:16 UTC, Aron Budea
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2017-05-30 05:16:31 UTC
Created attachment 133714 [details]
Sample

1. Open the attached sample (a file from the source repo's unit tests), or any file with pivot chart.
2. Update autofilter selection twice.
3. Undo twice.

=>
1st undo: pivot chart not updated.
2nd undo: pivot chart updated to reflect 1st undo state.

Reproduced using 5.5 master build (336f893c57c3c0281d4899629ad55603837d5d40) & 5.4 beta1 / Windows 7.
Comment 1 Jacques Guilleron 2017-05-30 10:27:35 UTC
Hi Aron,

I confirm this behavior on
LO 5.5.0.0.alpha0+ Build ID: 0e6297932252403883a6057feee488e4ee2bc360
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2017-05-23_00:14:17
Locale: fr-FR (fr_FR); Calc: CL

The pivot table autofilter is not updated on the first undo.
This issue doesn't exist in
LO 3.5.3.2 Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80
and begins with
LO 3.6.1.2 (Build ID: e29a214)
under Windows 7 Home.
I changed summary chart to table.

Jacques
Comment 2 Aron Budea 2017-06-01 10:23:55 UTC
Ok, if it's pivot-table-related, updating the META tracker it belongs to.
Comment 3 Xisco Faulí 2017-06-18 14:34:46 UTC
I can reproduce the problem in

Version 4.1.0.0.alpha0+ (Build ID: 8669ad398a2971706ce22b6e5fe316991977452)
Comment 4 Aron Budea 2018-02-05 23:46:44 UTC
Bibisected using bibisect-43all, bug introduced in the following range, probably by one of Kohei's commits dealing with pivot tables:
https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=0a8596dd8ebbbc80e87d4bdfafe3cf53355b7d43..c0a99301f5d854cad8baeaca798549424937598d
Comment 5 QA Administrators 2019-11-24 03:36:08 UTC Comment hidden (obsolete)
Comment 6 Roman Kuznetsov 2019-11-24 07:48:45 UTC
still repro in

Версия: 6.5.0.0.alpha0+ (x64)
ID сборки: 32dcf3f0fdafcf44457842a8aa4f54d30d856ca9
Потоков ЦП: 4; ОС:Windows 10.0 Build 17763; Отрисовка ИП: GL; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded
Comment 7 Robert Lacroix 2021-03-26 07:38:00 UTC
Repro in

Version: 7.0.4.2
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 12; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-CA (en_CA.utf8); UI: en-US
Calc: threaded

It is not just the chart that lags behind, the autofilter checkbox selections also lag behind. This is observable in a pivot table with or without a chart.
Comment 8 QA Administrators 2023-03-27 03:19:49 UTC Comment hidden (obsolete)
Comment 9 Aron Budea 2023-03-27 12:43:51 UTC
Still in LO 7.6.0.0.alpha0+ (7a7eb4aa21ca0c83db825fe8d5a5278611b391d8) / Ubuntu.
Comment 10 dosih 2023-04-03 08:50:41 UTC Comment hidden (spam)