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
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 > condition. 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 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?
I'm sorry to report that the LO 6.3.3.2 behaves as described in the first post in April 2019. I created two CFs and their position were exchanged (they landed on the sheet, where the dialogue box has been closed]. Also after manually creating only two CFs, the file ended up having three CFs. Version: 6.3.3.2 (x64) Build ID: a64200df03143b798afd1ec74a12ab50359878ed CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; Locale: cs-CZ (cs_CZ); UI-Language: en-US Calc: threaded
The issue is not present in Version: 7.1.0.0.alpha0+ (x64) Build ID: 7dc3a20cab712ee987ea25a8f5728529521485b7 CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win Locale: cs-CZ (cs_CZ); UI: en-US Calc: CL The CF equations stays with the original sheet, where the CF has been created. They are not assigned to sheets, which the CF has been confirmed at. Which is valid behavior.