Bug 114266 - EDITING: HANG if copy / paste very big number of cells with conditional formatting
Summary: EDITING: HANG if copy / paste very big number of cells with conditional forma...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.6 all versions
Hardware: All All
: high major
Assignee: Not Assigned
Keywords: bibisected, regression
Depends on:
Blocks: Conditional-Formatting Paste Performance CPU-AT-100%
  Show dependency treegraph
Reported: 2017-12-05 15:58 UTC by Rainer Bielefeld Retired
Modified: 2024-04-25 06:39 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Sample Document (23.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-12-05 16:01 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2017-12-05 15:58:15 UTC
Steps how to reproduce with Version: (x64)
Build ID: a5af0fd9f27af42cf2e8571f659cdad6e606215b  CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-11-07_00:30:02
Locale: de-DE (de_DE); Calc: CL:

1. Open attached "sample_001.ods"
2. Click A1
3. <ctrl-c> for copy
4. Click Column Heading "B"
5. <ctrl-v> for paste
   Expected: after few seconds paste is done, can continue editing
   Actual: hangs for a long time, with maximum CPU loac                  :-(
           I had to terminate LibO after 15 minutes or so

a) All my tests seem to show that the problem is related to 
   conditional formatting, other cells without c.f. do not show this problem
b) Already REPRODUCIBLE with Version: 
   Build-ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU-Threads: 4; 
   Betriebssystem:Windows 6.1; UI-Render: Standard; 
   Gebietsschema: de-DE (de_DE); Calc: group
c) all the same on WIN10
Comment 1 Rainer Bielefeld Retired 2017-12-05 16:01:47 UTC
Created attachment 138229 [details]
Sample Document

d) With 
   I found possible DUP or 
   related to 
   "Bug 109280 - conditional formatting not preserved with copy paste operations"
Comment 2 Rainer Bielefeld Retired 2017-12-05 17:26:05 UTC
e) Already REPRODUCIBLE with Version: 
   Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8
   That underpins suspect concerning relation to Bug 109280
f) assigning a c.f. to a complete column via 
   menu 'format → conditionla formatting' does not cause a problem
g) I hope there is a workaround? In my universe a spreadsheet without
   possibility to spread c.f. to a whole column is completely useless.
(d): Oops, related Bug or DUP is "Bug 103312 - Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow"
Comment 3 Xisco Faulí 2017-12-05 17:45:07 UTC
I can reproduce it back to

Version (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
(oldest bisect max commit)

but not in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-
Comment 5 Rainer Bielefeld Retired 2018-12-05 06:56:45 UTC
As expected still REPRODUCIBLE with Version: (x64)
Build-ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard;
Comment 6 Telesto 2020-04-05 20:59:01 UTC
Seems quite fine with
Version: (x64)
Build ID: 4501a0ba623ad61c5a4e0b807da2e96f0e4ce82c
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL
Comment 7 QA Administrators 2022-04-06 03:45:16 UTC Comment hidden (obsolete)
Comment 8 Rainer Bielefeld Retired 2022-04-06 05:01:38 UTC
Tested on my PC with AMD Ryzen 5 3600 6-Core Processor / 3.60 GHz  16,0 GB:

REPRODUCIBLE with Server Installation of Version: WIN10
Build-ID  7545bee9c2a0782548772a21bc84a9dcc583b89;  Special devUserProfile

No longer reproducible with  Installation of Version: (x64) 
Build ID a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win | Locale: de-DE (de_DE); UI: de-DE | Calc: threaded | ElementaryTheme | My normal User Profile

so WFM