https://bugs.documentfoundation.org/show_bug.cgi?id=150570
Bug ID: 150570
Summary: [FORMATTING] Editing conditional formatting by adding
a reference to another sheet can cause the wrong
condition to change
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Editing a conditional formatting with a formula referencing to another cell can
be edited via the interface. One can use the Format -> Conditional -> Manage to
edit a condition rule.
The UI can allow the user to edit in references to another sheet, however the
conditions will be applied to the sheet which is active after clicking OK.
Usually, this will be the cell the user wants to reference to.
One can even "add" a conditional formatting to a sheet which doesn't have any
this way. The condition does not seem to work, until the file is saved and then
re-opened. After doing that, a sheet which originally did not have a condition
will now have one.
There is a workaround: when editing the cell reference, always change the sheet
back to the one where the condition being edited is in. However, this is very
unintuitive, and the bug can result in possibly very complex conditions being
lost (albeit it seems CTRL+Z works), and confused users.
As a sidenote, adding a condition works correctly, despite the UI and process
being very similar (i.e. it does not add a condition to the sheet being
referenced to, despite it being the selected sheet when closing the dialog).
Steps to Reproduce:
1. Make a file with at least two sheets, with a conditional formatting in
sheets A and B (or just A)
2. Use Format -> Conditional -> Manage to edit a condition on sheet A with a
formula
3. Use the UI to select a cell to be referenced in sheet B on the condition on
sheet A, more precisely:
3.1) click on the formula field
3.2) click on sheet B
3.3) click on cell(s) to be referenced by the formula
4. click OK twice (do not change back to sheet A before this step, as no user
would do that either - but that would work around the bug indeed!)
Actual Results:
After clicking OK twice (to close the dialogs), the conditional formatting rule
in sheet A is unchanged. However, either one of the following happens:
1) a conditional formatting rule in sheet B gets overwritten
2) if sheet B does not have any conditional formatting rules, one will be
added.
Expected Results:
The conditional rule in sheet A should have been changed as the user requested.
The conditional rules in sheet B should never change, if a user chose a
condition in sheet A to be edited.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.4.0.3 / LibreOffice Community
Build ID: 40(Build:3)
CPU threads: 32; OS: Linux 5.19; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
7.4.0-2
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
