Description: In my Calc document, I have two sheets. In Sheet 1, there are already a few conditions. In Sheet 2, there are no conditions yet, but I intend to create one with a reference to a cell in Sheet 1. My new condition is created in Sheet 1, instead of Sheet 2, and all the conditions I previously had in Sheet 1 are gone. This is in addition to another bug I've encountered regarding conditions in Calc (https://bugs.documentfoundation.org/show_bug.cgi?id=165311). Steps to Reproduce: 1. I go to Sheet 2. 2. I select some cells. 3. I create a new condition. This condition depends on the value of cell B20 from Sheet 1. Actual Results: - Once the condition is created, I realize that it's been created in Sheet 1, instead of Sheet 2. - My previous conditions in Sheet 1 are gone. Expected Results: - As I originally created my condition in Sheet 2, my condition should stay in Sheet 2. - My previous conditions from Sheet 1 should remain unaffected. Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.2.2 (X86_64) / LibreOffice Community Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Created attachment 200140 [details] Calc document
Created attachment 200141 [details] Screen recording You can see, in this clip, that after creating, in Sheet 2, a condition with a reference to cell B20 from Sheet 1, my condition is created in Sheet 1, instead of Sheet 2. Also, all the conditions I had in Sheet 1 are gone.
Reproduced in Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fabdac1af8d30f849a94defd516d6699945f908d CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded and in Version: 6.4.0.0.alpha1+ Build ID: 9bc848cf0d301aa57eabcffa101a1cf87bad6470 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3; Locale: en-US (es_ES.UTF-8); UI-Language: en-US Calc: threaded the problem is reproducible when the current sheet is changed to another one while the dialog for creating a new conditional format is displayed
I think this is a duplicated of bug 150570 *** This bug has been marked as a duplicate of bug 150570 ***
The video indicates that you changed to sheet 1 to pick the reference of the cell value for the conditional formatting. To make it work correctly, you need to click on the sheet2 tab to come back to the sheet2 conditional formatting. Alternatively, don't use the mouse to pick the reference, but enter it manually. Admittedly, this is a behavior of the dialog that should be clarified or fixed. Note that the cell condition value text field does not have a "shrink" button to let you pick the reference, as other dialogs have or as indicated in the bottom of the condition dialog for the range of cell to apply conditional formatting. Summary: the bug shows silent swap of sheets in the conditional formatting edit dialog. Version: 25.2.2.2 (X86_64) / LibreOffice Community Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac CPU threads: 12; OS: Linux 6.11; UI render: default; VCL: kf5 (cairo+wayland) Locale: en-US (pt_BR.UTF-8); UI: en-US Calc: threaded
Yes, eventually I managed to create the condition manually, but using the mouse to select the cell is just easier, I think. So, is this considered a bug that could be corrected some day? The deletion of my other conditions is what bothers me most.