Description: In Calc, if you try to apply a Conditional Format to a cell which is alredy covered by an existing Conditional Format, a dialog pops up telling you that you can either edit the existing cond. format or create an overlapping one, and then asks "Do you want to edit the existing conditional format?" with No and Yes buttons. However clicking "No" (implying that the user want to create an overlapping condition) just exits without allowing a new conditional format to be created. If the intent is to not allow overlapping conditional formats, then the dialog should be changed to say that (currently it says you have a choice). If overlapping conditions *are* supposed to be allowed, then if the user clicks the button corresponding to that choice (i.e. "No" to "Do you want to edit..."), then a conditional-format-creation dialog should appear. Steps to Reproduce: 1. Loat attached "test.ods" spreadsheet 2. On sheet "Sheet2", select cell B1, then do Format->Conditional->Condition (dialog appears asking "Do you want to edit the existing cond. format?") 3. Click No Actual Results: The dialog closes and nothing else happens. Expected Results: Expected that a new overlapping conditional format could be created, as implied by the question in the dialog box Reproducible: Always User Profile Reset: No Additional Info: .
Created attachment 167457 [details] test.ods (see steps to reproduce)
Hrm... actually, if you answer "Yes" to the question "Do you want to edit the existing conditional format?" then you can not edit the existing format; it appears to be asking for a new format. So it looks like the question is asking the opposite of what it means
first - there is no Sheet2 in your attached file second - i can't confirm your "problem" from scratch, because I don't see that window with question that will ask "Do you want to edit the existing conditional format?" =(
Created attachment 168505 [details] Revised demo spreadsheet (follow instructions using cell A1)
My apologies! I don't know what happened, I must have attached the wrong file. Please try the revised spreadsheet. Select A1, then do Format->Conditional->Condition and the question dialog will appear ("Do you want to edit the existing conditional format?"). Answer "no" (meaning you want to define a new overlapping conditional format, as suggested in the dialog). The window closes with no other action.
(In reply to Jim Avera from comment #5) > Select A1, then do Format->Conditional->Condition > > and the question dialog will appear ("Do you want to edit the existing > conditional format?"). > > Answer "no" (meaning you want to define a new overlapping conditional > format, as suggested in the dialog). The window closes with no other action. Confirmed with attachment 168505 [details] The file sc/source/ui/view/cellsh1.cxx is talking about overlapping conditional formats. Arch Linux 64-bit Version: 7.3.0.0.alpha1+ / LibreOffice Community Build ID: 8c66455df8f6a26c314290f252bedbc19db6b327 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 25 November 2021
No longer reproducible in current or daily master build. Closing ticket as WORKSFORME Version: 7.6.1.2 (X86_64) / LibreOffice Community Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674 CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 486ae5db6987411d5e394de94b2b077099d03856 CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Indeed, overlapping conditions can be created now Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a34dcd03254480927c403d904c0e754802d97b90 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded