Summary: | [FORMATTING] Editing conditional formatting by adding a reference to another sheet can cause the wrong condition to change | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Ville Aakko <ville.aakko> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | ilmari.lauhakangas |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 5.3.0.3 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=96453 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | Markus Mohrhard | |
Bug Depends on: | |||
Bug Blocks: | 116222 | ||
Attachments: | A LO calc file which can be used to reproduce the bug. |
Description
Ville Aakko
2022-08-23 20:59:08 UTC
(In reply to Ville Aakko from comment #0) > Steps to Reproduce: > 1. Make a file with at least two sheets, with a conditional formatting in > sheets A and B (or just A) Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document. Created attachment 185032 [details]
A LO calc file which can be used to reproduce the bug.
I've attached an example document (for what it is worth);
however I have to point out that an example document is almost pointless in this case, as this is a bug in the interface. There is no way to make an example document which would be an example of the bug just by existing as a document. The user (or developer) still needs to reproduce the steps I've outlined in the report.
In the context of the example file, I'm just repeating stuff in the report below:
Sheet "A" has a conditional formatting (containing a formula). Use the steps in the description to manage the condition in sheet "A". Try to change the referenced cell to one in the "B" sheet, say, B.C3.
Note: use the mouse (UI), don't type. The relevant trigger for the bug is to change to a different sheet when managing the condition in a sheet, and clicking OK when the other sheet is selected as the active (shown sheet).
As a result, the condition originally selected to be managed is not changed, but another one created (or an existing one edited) erroneously.
Tested with the file and could not reproduce. Condition can be changed fine without side effects. Arch Linux 64-bit, X11 Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a389e6bd7aacfa4e1ff1ea3a46199fb381d1131f CPU threads: 8; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 10 July 2023 Hi, I have re-tested this again on Arch Linux. I can still reproduce this using the libreoffice-fresh package. It is of course possible it has been fixed on the alpha build. Buvjaga, Just to make sure, as your wording is a bit unclear: this bug is not about inability to change conditional formatting - most can be changed without any issues. The issues arise only if the user references cells in a different sheet to where the condition is being applied to. Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 32; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: fi-FI 7.5.5-1 Calc: threaded (In reply to Ville Aakko from comment #4) > Hi, > > I have re-tested this again on Arch Linux. I can still reproduce this using > the libreoffice-fresh package. It is of course possible it has been fixed on > the alpha build. > > Buvjaga, Just to make sure, as your wording is a bit unclear: this bug is > not about inability to change conditional formatting - most can be changed > without any issues. The issues arise only if the user references cells in a > different sheet to where the condition is being applied to. Sure, I went by the steps in the description and nothing unusual happened. Whoops, I must have been careless with observing the result. I do reproduce now that a new condition is created in sheet B while the one in A is left intact. Bibisected with linux-64-5.3 repo to 5b8c22379e2eae74f7ed78326ab89483db5c6624 tdf#96453, tdf#100793 rework transfer of data between cond format dlgs |