Bug 112775 - Conditional Formatting goes crazy creating new range rules
Summary: Conditional Formatting goes crazy creating new range rules
Status: RESOLVED DUPLICATE of bug 87274
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.6.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-09-30 15:11 UTC by Aprax
Modified: 2017-10-01 23:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
1 OK to start with (22.43 KB, image/png)
2017-09-30 15:11 UTC, Aprax 		Details
2 insert a new row 32 (240.47 KB, image/png)
2017-09-30 15:11 UTC, Aprax 		Details
3 Conditional Formatting rules haven't changed yet (22.54 KB, image/png)
2017-09-30 15:12 UTC, Aprax 		Details
4 but after copying row 36 and pasting to 32 it gets terrible (25.97 KB, image/png)
2017-09-30 15:14 UTC, Aprax 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Aprax 2017-09-30 15:11:11 UTC 
Created attachment 136640 [details]
1 OK to start with

1) all column ranges are from row 4 to 1048576
2) a new row 32 is inserted
3) all column ranges are from row 4 to 1048576
copy row 36 and paste in new row 32
4) what is the logic to create all these new rules for columns that are not used in the sheet?

I know this doesn't happen if Copy and paste special is used but an accidental Paste instead of Paste Special really screws things up and takes time to fix.
Comment 1 Aprax 2017-09-30 15:11:55 UTC 
Created attachment 136641 [details]
2 insert a new row 32
Comment 2 Aprax 2017-09-30 15:12:44 UTC 
Created attachment 136642 [details]
3 Conditional Formatting rules haven't changed yet
Comment 3 Aprax 2017-09-30 15:14:15 UTC 
Created attachment 136643 [details]
4 but after copying row 36 and pasting to 32 it gets terrible
Comment 4 Xavier Van Wijmeersch 2017-10-01 08:43:51 UTC 
confirm with, and the same with dragging the mouse around

Version: 6.0.0.0.alpha0+
Build ID: d784dc4fd4e7b8b1f7468dd3fe1c952f8ab7037f
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 5 m_a_riosv 2017-10-01 23:45:02 UTC 
I think the same matter than tdf#87274

Please if you are not agree, reopen it.

*** This bug has been marked as a duplicate of bug 87274 ***