Created attachment 198838 [details] Screenshot 1. Create a spreadsheet with multiple sheets, let's call them "Sheet 1" and "Sheet 2", "Sheet 3", etc. 2. In "Sheet 2", select a range of cells, apply conditional formatting to them 3. Switch to "Sheet 1" or "Sheet 3" 4. In Conditional > Manage…, access the "Manage Conditional Formatting" dialog Result: you can see the range of cells from "Sheet 2" in that dialog, even if you are in sheet 1 and 3. This is actually pretty nice, however there is no visual indication that they are in another sheet, and selecting one of the rows in this management dialog does not automatically select the related sheet to show what the cells range refers to. Expected result: * There should probably be a "Sheet" column before the "Range" column, containing at least a portion of the sheet name (ellipsized if it's too long) and sheet tab color, so that it is easier to know what comes from where. * Maybe it should auto-switch to the appropriate sheet and visually show the affected range for any selected row in that dialog, but I'm not sure if this can be pulled off, because that dialog obscures the view anyway. --- Observed on: Version: 24.8.4.2 (X86_64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak Calc: threaded
This is not the case in Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded In 25.2 you get nothing in another sheet. Maybe it was solved meanwhile. Could you test 25.2? It will be released next month (2025.02).
Ah you are right Bogdan, with the 25.2 release having come through the flatpak pipe now, I can see that this just-released version does not show conditions from other sheets at all. I thought showing the conditions from all sheets was expected* behavior, just that in that case it should also identify which sheet they are from… *: maybe the ability to show conditions ranges from all sheets would be better if it was something you can toggle on with a checkbox switch in the dialog.