Bug 123927 - EDITING Calc doesn’t show conditional formatting on subset of range
Summary: EDITING Calc doesn’t show conditional formatting on subset of range
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
: 135140 (view as bug list)
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2019-03-07 15:40 UTC by NISZ LibreOffice Team
Modified: 2022-07-28 03:39 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file (7.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-07 15:42 UTC, NISZ LibreOffice Team
Details
Screenshot (153.36 KB, image/png)
2019-03-07 15:42 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-03-07 15:40:47 UTC
Description:
LibreOffice Calc 6.3.0.0.alpha0+ doesn’t show conditional formatting on subset of range.

Steps to Reproduce:
    1. Open LibreOffice Calc.
    2. Use Conditional formatting on a Range.
    3. Select a subset of the formatted Range.
    4. Select Conditional Formatting on Quick menu.
    5. View the attached screenshot.
    6. Notice, that previous formatting does not appear.

Actual Results:
The previously set formatting does not appear in LibreOffice Calc 6.3.0.0.alpha0+.

Expected Results:
The previously set formating should be appear in LibreOffice Calc 6.3.0.0.alpha0+.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.3.0.0.alpha0+
Build ID: 65438bcda46bab4f2fe6fb555f44aace45e11e5e
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded
Comment 1 NISZ LibreOffice Team 2019-03-07 15:42:06 UTC
Created attachment 149802 [details]
Example file
Comment 2 NISZ LibreOffice Team 2019-03-07 15:42:40 UTC
Created attachment 149803 [details]
Screenshot
Comment 3 m_a_riosv 2019-03-08 03:27:24 UTC
No issue for me with:
Version: 6.3.0.0.alpha0+ (x64)
Build ID: 9c5dbbe4b0a62ff1af009beb00f1fc45318dad79
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-02-27_20:03:12
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 4 mulla.tasanim 2019-03-27 19:47:11 UTC
Thank you for reporting the bug.

I can confirm that the bug is present in

Version: 6.2.1.2 (x64)
Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: CL


Version: 6.3.0.0.alpha0+ (x64)
Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-08_00:38:10
Locale: en-US (en_US); UI-Language: en-US
Calc: CL
Comment 5 Xisco Faulí 2019-03-28 12:24:02 UTC
Also reproduced in

Version: 5.4.0.0.alpha1+
Build ID: 9feb7f7039a3b59974cbf266922177e961a52dd1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

but not in

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default;
Comment 6 raal 2019-04-11 16:18:51 UTC
This seems to have begun at the below commit.
Adding Cc: to Markus Mohrhard; Could you possibly take a look at this one? Thanks
 c575cac0f572fea83b1ef6b8d7e0e0b2ccc94315 is the first bad commit
commit c575cac0f572fea83b1ef6b8d7e0e0b2ccc94315
Author: Norbert Thiebaud <nthiebaud@gmail.com>
Date:   Mon Sep 19 03:52:16 2016 -0700

    source 5b8c22379e2eae74f7ed78326ab89483db5c6624

author	Markus Mohrhard <markus.mohrhard@googlemail.com>	2016-09-18 16:14:35 +0200
committer	Markus Mohrhard <markus.mohrhard@googlemail.com>	2016-09-19 10:10:09 +0000
commit 5b8c22379e2eae74f7ed78326ab89483db5c6624 (patch)
tree 60cbfdd24bca243b4a911ff1dab298ef91590b5b
parent 96646c351e20fa6699fa368457a05ee70f76f103 (diff)
tdf#96453, tdf#100793 rework transfer of data between cond format dlgs
Comment 7 raal 2020-07-27 21:38:58 UTC
*** Bug 135140 has been marked as a duplicate of this bug. ***
Comment 8 QA Administrators 2022-07-28 03:39:16 UTC
Dear NISZ LibreOffice Team,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug