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: RESOLVED WORKSFORME
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: 2024-10-10 11:37 UTC (History)
9 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 Comment hidden (obsolete)
Comment 9 QA Administrators 2024-07-28 03:15:01 UTC Comment hidden (obsolete)
Comment 10 Timur 2024-10-10 11:37:15 UTC
Seems this was fixed somewhere.
With 7.0, range dialog was there, but range would still be just selected.
With 7.5 and 24.2, Yes in range dialog shows the whole CF range.