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