Bug 141068 - [EDITING] Undo can fragment conditional formatting
Summary: [EDITING] Undo can fragment conditional formatting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 162137 (view as bug list)
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2021-03-16 15:01 UTC by Alan Frank
Modified: 2024-07-22 16:59 UTC (History)
3 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 Alan Frank 2021-03-16 15:01:13 UTC
Description:
If you expand a range which has conditional formatting (CF), then undo the action, the CF definition will be fragmented.

Steps to Reproduce:
1. Create data in A1:C3
2. Create a conditional formatting (CF) rule on that data
3. Select A3:C3
4. Using the black box in the lower-right of C3, stretch to copy data and include row 4.  This properly expands the CF to include row 4.
5. Undo 

Actual Results:
There are now two CF definitions, one for rows 1:2 and another for row 3

Expected Results:
The state should be identical to that before the expansion, with one CF definition encompassing rows 1:3


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.5.2 (x64)
Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

See log a726b36747cf2001e06b58ad5db1aa3a9a1872d6
Comment 1 [REDACTED] 2021-03-17 14:52:40 UTC
No repro

Version: 7.1.1.2 / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

No repro

Version: 7.1.1.2 (x64) / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 1; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_DE); UI: de-DE
Calc: threaded
Comment 2 [REDACTED] 2021-03-17 14:56:38 UTC
No repro

Version: 6.3.6.2
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kde5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 3 [REDACTED] 2021-03-17 15:23:06 UTC
No repro in 

Version: 6.4.5.2 (x64)
Build-ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU-Threads: 1; BS: Windows 10.0 Build 19042; UI-Render: Standard; VCL: win; 
Gebietsschema: en-US (en_DE); UI-Sprache: de-DE
Calc: threaded
Comment 4 [REDACTED] 2021-03-17 15:26:32 UTC
(In reply to Alan Frank from comment #0)
> 
> User Profile Reset: No
> 

Could you please try to perform the "Steps to Reproduce:" while running in *Safe Mode* reset you user profile if it works while running in safe mode?

See also https://wiki.documentfoundation.org/UserProfile
Comment 5 Roman Kuznetsov 2021-03-18 17:12:51 UTC
no repro in

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d97528da0c70c43fccd3239cbe8e064c3480bba8
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL
Comment 6 Alan Frank 2021-03-21 14:00:19 UTC
Uwe Auer conjectured, and I have confirmed, that the reason some people have not been able to reproduce the issue is that it doesn't happen for all types of conditional formatting.  It *does* happen with color scales and *does not* happen with conditions (such as "value equals 4").  I have checked this on both the stable and development versions.
Comment 7 [REDACTED] 2021-03-22 19:11:11 UTC
Reporter is referring to discussion in https://ask.libreoffice.org/en/question/298790/calc-inconsistency-in-copying-cells-with-conditional-formatting/ - where I'm known as Opaque.
Comment 8 Xisco Faulí 2021-04-30 10:09:35 UTC Comment hidden (obsolete)
Comment 9 BogdanB 2021-07-30 20:15:42 UTC Comment hidden (obsolete)
Comment 10 BogdanB 2021-07-30 20:16:54 UTC Comment hidden (obsolete)
Comment 11 BogdanB 2021-07-30 20:19:58 UTC
Also in Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 5aa74aa1e6fac571f99146ebcb6adc9feb1459ad
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-28_19:35:14
Calc: threaded

Tested with Color scale
Comment 12 raal 2024-07-22 16:59:05 UTC
*** Bug 162137 has been marked as a duplicate of this bug. ***