calc: conditional formatting edit message

Version: (x86)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

When there is already conditional formatting, and I click on the conditional formatting ‘condition’ tool, I am always presented with a dialog that asks

"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?"

If I say ‘yes’ it enters the formatting dialog. If I say ‘no’, it just exits. This dialog box is therefore 100% useless, since I can just cancel in the formatting dialog. So:

  1. That’s a bug, maybe fix it some day.
  2. How do I disable it asking me that question, and just open the formatting dialog that I am trying to get to?


What your are looking for is: Format -> Conditional -> Manage, which allows to modify existing conditional formatting, while in fact edit the existing conditional format means create a new conditional formatting (an which may cause precedence problems with existing rules)