Bug 129814 - conditional formatting rules split when they shouldnt
Summary: conditional formatting rules split when they shouldnt
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:7.6.0 target:7.5.4
Keywords:
: 151880 (view as bug list)
Depends on:
Blocks: Conditional-Formatting-Managing
  Show dependency treegraph
 
Reported: 2020-01-05 17:55 UTC by pajaro
Modified: 2023-04-28 08:53 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
file with the error (24.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-01-05 17:56 UTC, pajaro
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pajaro 2020-01-05 17:55:34 UTC
Description:
when i copy paste rows, conditional rules split even tho both lines have the same rules applied to them



Steps to Reproduce:
1. check conditional formating: 5 rules
2. select row 8. ctrl + c
3. select row 9. ctrl + v overwrite? yes
4. check conditional formating: 6 rules

Actual Results:
6 rules

Expected Results:
5 rules


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 pajaro 2020-01-05 17:56:09 UTC
Created attachment 156948 [details]
file with the error
Comment 2 m_a_riosv 2020-01-05 22:23:13 UTC
I think we can close as duplicate.
Please if you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 87274 ***
Comment 3 pajaro 2020-01-06 12:32:05 UTC
I was told to open this bug by Mike Kaganski Which has been working on this

Also, The linked bug is a nice enhancement that i root for because i use a lot of conditional formating, but this is a bug

And that bug is 6 years old now. I hope this is easier to fix :(
Comment 4 m_a_riosv 2020-01-06 23:06:11 UTC
Then I hope Mike find the time to resolve it. He has comments on the other bug.
Comment 5 QA Administrators 2022-08-12 03:50:01 UTC Comment hidden (obsolete)
Comment 6 pajaro 2022-08-12 08:04:58 UTC
still happens
Version: 7.4.0.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 5.18; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Debian package version: 1:7.4.0~rc2-3
Calc: threaded
Comment 7 Commit Notification 2023-04-26 09:40:38 UTC
Tibor Nagy committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/3fa15dd614bd72ddb36dbe033abeef5609d31f38

tdf#154906 tdf#129813 tdf#129814 sc: fix conditional format color scale

It will be available in 7.6.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 8 Tibor Nagy 2023-04-26 11:22:06 UTC
*** Bug 151880 has been marked as a duplicate of this bug. ***
Comment 9 Commit Notification 2023-04-28 08:53:57 UTC
Tibor Nagy committed a patch related to this issue.
It has been pushed to "libreoffice-7-5":

https://git.libreoffice.org/core/commit/f2034af7eee1174481c4220decea51d00e8b8ab0

tdf#154906 tdf#129813 tdf#129814 sc: fix conditional format color scale

It will be available in 7.5.4.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.