Bug Hunting Session
Bug 124718 - FORMATTING Conditional Formatting Manage dialog losses focus on selected sheet (keeps range relative)
Summary: FORMATTING Conditional Formatting Manage dialog losses focus on selected shee...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.7.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
 
Reported: 2019-04-13 13:10 UTC by milan.berta
Modified: 2019-04-16 14:41 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
conditional format screenshots (2.29 MB, application/pdf)
2019-04-13 16:23 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description milan.berta 2019-04-13 13:10:30 UTC
The Manage Conditional Formatting (CF) dialog does not remember the sheet for the selected cell range, when changing sheets while editing the condition.

Steps to reproduce:
* In empty file, create new sheet (2 sheets are available now)
* Start in Sheet1 and add new condition which is linked to the Sheet2: Choose any single cell, e.g. A1, open dialog for CF, add new, "Cell value is not equal Sheet2.B2". Choose the value Sheet2.B2 by selecting the Sheet2 and the cell there. Note that the cell range in the dialogue box still remains A1 and not Sheet1.A1. Confirm the CF while still on Sheet2.
* Open the CF dialog box on Sheet1. There is no condition. (Awaited: there is a condition.)
* Open the CF dialog box on Sheet2. There is the condition. (Awaited: There is no condition.)

This goes so far that if I now do the same process from Sheet2 to Sheet1. The 1st condition will be copied to Sheet1. And there will be three conditions altogether -- although only two have been added by the user as new.

Version: 6.1.5.2 (x64)
Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU threads: 8; OS: Windows 10.0; UI render: default; 
Locale: cs-CZ (cs_CZ); Calc: group threaded

Version: 6.2.2.2 (x64)
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: cs-CZ (cs_CZ); UI-Language: en-US
Calc: threaded
Comment 1 Oliver Brinzing 2019-04-13 16:23:48 UTC
Created attachment 150736 [details]
conditional format screenshots
Comment 2 Oliver Brinzing 2019-04-13 16:26:27 UTC
reproducible(In reply to milan.berta from comment #0)
> The Manage Conditional Formatting (CF) dialog does not remember the sheet
> for the selected cell range, when changing sheets while editing the
> condition.

reproducible, the conditional format is set for the cell in sheet2
Comment 3 m.a.riosv 2019-04-13 23:19:59 UTC
It's needed to remember that CF only works per sheet context, so a CF done in a sheet only works in that sheet.

Seems the issue here is that the condition is added on the sheet where the cursor is after select with the mouse. Introducing the formula by hand works fine for me.
Comment 4 Oliver Brinzing 2019-04-14 06:19:53 UTC
(In reply to m.a.riosv from comment #3)
> Seems the issue here is that the condition is added on the sheet where the
> cursor is after select with the mouse. Introducing the formula by hand works
> fine for me.

the behaviour changed with LO 5. with LO 4 it was not possible to change between sheets while the "Conditional Formating for" dialog was open.

To solve the problem, the originally selected cell/range could be displayed with preceding sheetname in "Range" field.
Comment 5 Roman Kuznetsov 2019-04-16 14:41:47 UTC
don't repro in

Version: 6.3.0.0.alpha0+
Build ID: 3083fe569f96bf0289da1e9d0ef7da15ab22e2f6
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-04-16_01:39:55
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

people, can you retest it in latest master?