Bug 165557 - conditional formattings: editing one twice gives weird dialogue
Summary: conditional formattings: editing one twice gives weird dialogue
Status: RESOLVED DUPLICATE of bug 160252
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.1.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-03 22:55 UTC by Christoph Anton Mitterer
Modified: 2025-03-05 08:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Christoph Anton Mitterer 2025-03-03 22:55:54 UTC
Hey.

That seems to be a regression (though no idea since when).

When I do Format/Conditional/Manage and there Edit… and existing formatting, leave that again and - without leaving the "Manage Conditional Formatting" dialogue click on Edit… again, I get a spurious dialogue:

"The selected cell already contains conditional formatting. You can either edit the existing conditional format or you define a new overlapping conditional format.
Do you want to edit the existing conditional format?
"

First... I already clicked "Edit…" what else then edit should I want to do? Second, if I click yes now, it simply falls back to the "Manage Conditional Formatting" dialogue.

If I then click Edit… again, it works again (once).


Cheers,
Chris.
Comment 1 m_a_riosv 2025-03-04 01:20:22 UTC
Not reproducible
Version: 25.2.1.2 (X86_64) / LibreOffice Community
Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49
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
Comment 2 Buovjaga 2025-03-04 04:34:10 UTC
Please copy and paste here the content of your Help - About (LibreOffice - About on macOS) by clicking the copy button. This allows us to know more about your system.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.
Comment 3 Christoph Anton Mitterer 2025-03-04 04:37:51 UTC
Version: 25.2.1.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_DE.UTF-8); UI: en-US
Debian package version: 4:25.2.1-2
Calc: threaded
Comment 4 Christoph Anton Mitterer 2025-03-04 04:56:19 UTC
Reproducer:
1. create a new spreadsheet
2. Format / Conditional / Manage
3. Add
   is equal to: 0
   Range: A1:D100
   OK
4. Add
   is equal to: "foo"
   Range: B1:B100
   OK
   => another bug,.. here *both* dialogues simply go away, when going back to
   Format / Conditional / Manage ... only the rule from (4) is there.
   A similar issue happens when 
5. re-do (3)
   now there should be two rules
   OK
6. go back to Format / Conditional / Manage
7. Edit... twice, and with the 2nd time you should see that "error message" from my original report.
8. Another bug: if, the "error message" from (7) is <Esc>aped, an empty fresh rule dialogue shows up. If <Esc>ing that, too, the main "Manage Conditional Formatting" dialogue is no longer there.
Comment 5 Xisco Faulí 2025-03-04 10:13:35 UTC
Thanks for reporting this issue.
This issue is fixed by 35c2320dcc2e0a492d5d85133081ed040578483d and it should be fixed in LibreOffice 25.2.2
Closing as duplicated of bug 160252

*** This bug has been marked as a duplicate of bug 160252 ***
Comment 6 Christoph Anton Mitterer 2025-03-05 00:16:33 UTC
@Xisco

Thanks.

Does the other fix also cover the additional stuff I've described in comment 4? :-)
Comment 7 Xisco Faulí 2025-03-05 08:52:44 UTC
(In reply to Christoph Anton Mitterer from comment #6)
> @Xisco
> 
> Thanks.
> 
> Does the other fix also cover the additional stuff I've described in comment
> 4? :-)

yes. you can test it yourself with a daily build from https://dev-builds.libreoffice.org/daily/master/current.html