Bug 41645 - Conditional FORMATTING pivot table disappears on refresh
Summary: Conditional FORMATTING pivot table disappears on refresh
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting Pivot-Table
  Show dependency treegraph
Reported: 2011-10-10 04:05 UTC by Winfried Donkers
Modified: 2020-04-22 21:38 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Winfried Donkers 2011-10-10 04:05:18 UTC
When using conditional formatting on cells in pivot table, calling refresh (via right mouse button contectmenu-refresh or via menu-data-pivot table-refresh) to update the pivot table (e.g. after changes in the data tables) causes the conditional formatting to disappear.
Comment 1 Björn Michaelsen 2011-12-23 12:39:44 UTC Comment hidden (obsolete)
Comment 2 Winfried Donkers 2011-12-24 01:21:13 UTC
bug still present on master (3.6.0alpha+, openSUSE 12.1)
Comment 3 g_bee 2012-05-25 20:50:55 UTC
Ok, now that I am registered with Bugzilla, I am confirming that this bug persists in 3.5.   Hoping it gets fixed soon.
Comment 4 m.a.riosv 2012-07-31 23:45:35 UTC
I think is not a bug, Pivot tables always overwrite all the destination area, values and formats.
Maybe can be set as enhancement.
Comment 5 QA Administrators 2015-01-05 17:52:19 UTC Comment hidden (obsolete)
Comment 6 Winfried Donkers (retired) 2015-01-06 11:09:00 UTC
Problem still persists in version
My current master is broken, so cant test there.

WRT comment #4 I think that refreshing pivot tables should just overwrite the values, not the formatting.
Comment 7 Gordon 2015-02-02 18:17:39 UTC
Using current version and working with Calc.

Pivot tables are formatted using one set of format titles in the Styles library
If using several pivots against the same set of data, such as to create an order, invoice, bill of lading, summary, etc., it would be useful to allow each table to use its own formatting. 
Suggestion: When editing a pivot, have the option to retain formatting that has been applied or overwrite formatting on refresh. (As is permitted in Excel).

This is my first post, so please forgive if submitted incorrectly.
Comment 8 QA Administrators 2016-02-21 08:37:36 UTC Comment hidden (obsolete)
Comment 9 Winfried Donkers (retired) 2016-02-22 08:53:01 UTC
Problem still there in version 5.0.4 (Windows 7).
Comment 10 QA Administrators 2017-03-06 15:55:27 UTC Comment hidden (obsolete)
Comment 11 Winfried Donkers (retired) 2017-03-07 11:08:45 UTC
Problem still there in version 5.2.5 (Windows 7).
Comment 12 QA Administrators 2019-04-04 03:04:35 UTC Comment hidden (obsolete)
Comment 13 Winfried Donkers (retired) 2019-04-04 06:01:03 UTC
Problem still there in version (Windows 10).
Comment 14 Sven Neuz (SERPENTEQ) 2020-04-14 10:13:47 UTC
I can confirm this bug for x64 on Windows 10.

Also sorting gets lost on refresh.
Comment 15 armand 2020-04-22 21:38:13 UTC
Same here