[Libreoffice-bugs] [Bug 141389] New: FORMATTING: Remember and/or indicate the active sheet when managing conditional formatting

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141389

            Bug ID: 141389
           Summary: FORMATTING: Remember and/or indicate the active sheet
                    when managing conditional formatting
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: psychonaut at nothingisreal.com

Description:
If you add or edit conditional formatting using the Managing Conditional
Formatting dialogue, then the conditional formatting gets applied only to
whatever sheet happens to be active at the time the OK button is pressed.  This
almost never what the user is expecting, particularly for the case where the
user uses the mouse to select a cell in a different sheet as the value of the
"Cell value" field.  In that case, the active sheet will change, and if the
user wants their conditional formatting applied to the sheet from which they
launched the Managing Conditional Formatting dialogue, they need to manually
switch back to it first.  It would be helpful if Calc would give the user some
conspicuous indication of what sheet the conditional formatting is going to be
applied to, and/or always applied the conditional formatting to the sheet from
which they launched the Managing Conditional Formatting dialogue in the first
place.


Steps to Reproduce:
1. Create a spreadsheet with two sheets named Sheet1 and Sheet2.  Enter "foo"
into cell A1 of Sheet1 and cell A1 of Sheet2.
2. With cell A1 of Sheet1 active, run Format->Conditional->Manage.  The Manage
Conditional Formatting dialogue appears.
3. Press the Add button. A Conditional Formatting for A1 dialogue appears.
4. Click on the input field next to the Cell value/is equal to drop-down boxes
in Condition 1.
5. Click on Sheet2 and select cell A1.  The text "$Sheet2.$A$1" appears in the
input field.
6. Select "Bad" in the "Apply Style" drop-down box.
7. Press the OK button.  The Conditional Formatting for A1 dialogue disappears.
8. Press the OK button.  The Manage Conditional Formatting dialogue disappears.
9. Activate Sheet1.


Actual Results:
Cell A1 of Sheet1 doesn't get any conditional formatting.  And in fact if
Format->Conditional->Manage is run while Sheet1 is active, the Managing
Conditional Formatting window doesn't list any conditional formats at all.  If
you cancel the dialogue and run the same command when Sheet2 is active, the
conditional format just created is then listed.  So basically the conditional
format got applied only to Sheet2, not to Sheet1.

Expected Results:
Cell A1 of Sheet1 should be formatted in red, per the "Bad" style.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.1.0.3 / LibreOffice Community
Build ID: 10(Build:3)
CPU threads: 12; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: en-GB (en_US.UTF-8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210331/efd7d615/attachment.htm>