https://bugs.documentfoundation.org/show_bug.cgi?id=164909
Bug ID: 164909
Summary: "Manage Conditional Formatting" dialog shows ranges
from all sheets, but does not indicate which sheet
they are from
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198838
--> https://bugs.documentfoundation.org/attachment.cgi?id=198838&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
