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: 126.96.36.199 (x64)
Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU threads: 8; OS: Windows 10.0; UI render: default;
Locale: cs-CZ (cs_CZ); Calc: group threaded
Version: 188.8.131.52 (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
Created attachment 150736 [details]
conditional format screenshots
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
reproducible, the conditional format is set for the cell in sheet2
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.
(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.
don't repro in
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
people, can you retest it in latest master?