Bug 133112 - Cell formatting (color) of some cells change after Undo (conditional formatting)
Summary: Cell formatting (color) of some cells change after Undo (conditional formatting)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2020-05-17 10:37 UTC by Telesto
Modified: 2023-01-31 14:04 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2020-05-17 10:37:35 UTC
Cell formatting (color) of some cells change after Undo

Steps to Reproduce:
1. Open attachment 131664 [details]
2. Select the area between B6 K30
3. Cut (or delete all cell content)
4. Undo -> Notice formatting change for B13 and B11 (no before/ colored after)

Actual Results:
Formatting changes for cell B11 and B13. No formatting before.. formatted after 

Expected Results:
Shouldn't happen

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64)
Build ID: f9790da286f2d2fa47f1748f8cfa6172c6622ca3
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: de-CH (nl_NL); UI: en-US
Calc: CL

also in

but not in
Comment 1 Telesto 2020-05-17 10:42:19 UTC
Increasing importance.. It's a sneaky bug; something you maybe not notice.
Comment 2 Attila Baraksó (NISZ) 2020-05-17 11:35:42 UTC
Reproduced in:

Version: (x64)
Build ID: a7f2239e649ea1b9ef611d758841584ab51abed0
CPU szálak: 4; OS: Windows 10.0 Build 17134; Felületmegjelenítés: Skia/Raster; VCL: win; 
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL
Comment 3 Attila Baraksó (NISZ) 2020-05-17 12:02:11 UTC
Bibisected using bibisect-win32-6.1 to:
URL: https://cgit.freedesktop.org/libreoffice/core/commit/?id=3f614f431475e1bf3bb3bbeac59b0681309628b7
author: Mike Kaganski <mike.kaganski@collabora.com>
committer: Eike Rathke <erack@redhat.com>
summary: tdf#95295: don't add duplicate conditional formats

Adding Cc: Mike Kaganski
Comment 4 Prince Singh Tomar 2020-12-25 11:22:52 UTC
Reproduced in:

Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-IN (en_IN); UI-Language: en-US
Calc: threaded

and also in :

Build ID: 828a45a14a0b954e0e539f5a9a10ca31c81d8f53
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
Comment 5 Xisco Faulí 2021-02-11 09:42:31 UTC
Still reproducible in

Version: / LibreOffice Community
Build ID: 066799b4a162aa0a4bc6aa28339f1f943a13971e
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 6 Mike Kaganski 2021-04-30 08:29:42 UTC
In no way could it be high/critical, even telling about "something you maybe not notice". There is no data loss; the conditional formatting regions are merged in correct way (even though of course it should not happen on undo, which is a bug, but not a critical bug). The coloring is even restored on save-and-reload. Please don't play randomly with priority.
Comment 7 Xisco Faulí 2021-04-30 10:09:35 UTC
*** Bug 141068 has been marked as a duplicate of this bug. ***
Comment 8 BogdanB 2021-07-30 20:15:42 UTC Comment hidden (obsolete)