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
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
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
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
(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
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
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.
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.
Thanks for reporting this issue. It looks like a duplicate of bug 133112 *** This bug has been marked as a duplicate of bug 133112 ***
*** This bug has been marked as a duplicate of bug 133112 ***
Sorry, I have seen Xixco comments.
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