[Libreoffice-bugs] [Bug 133242] Calc conditional formatting condition dialog (ui) changes to no condition after copy: regression

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133242

--- Comment #3 from pb <blicher at comcast.net> ---
The answer to your question is yes, the same dialog obtained by clicking the
'condition' conditional formatting icon.

Checking Format > Conditional > Condition..., it does indeed show that both
cells have the correct formatting information.

However, what I report is still a bug.  Because the 'condition' tool refers to
the single cell which is selected (or at least that's what a reasonable user
would expect), it should report what the formatting is *for that cell*.  It
does have what I consider to be the correct behavior in v5.0.1.

In addition,
If, again using the condition tool as in my original report, I create a format
for a random cell, then use it again to create the same format for some other
random cell, after that the condition tool *does* still show each cell's
conditional format.  There is no reason *from the user's perspective* why that
should result in different behavior.  (...even if it might make sense from the
perspective of simplifying the code.)

As for the 'manage' dialog, it is also inconsistent, because when the condition
is copied, it shows the copies as a list, but when created independently, it
shows them independently.  What's more, it appears that using the condition
tool (icon) ADDS a shadowing condition, rather than EDITING the existing
condition as the intervening dialog asserts.

Most of this is counterintuitive, i.e. bad UI/UX design.

At the very least, the "condition" tool should be called "add a condition
without showing you any previous conditions that might apply to this cell, and
that will not change any of the previous conditions."

The way I would expect this all to work would be that the 'condition' tool
would show the user ALL conditions that apply to that cell, and allow the user
to edit each of them.  If a cell's property is copied, the state of the copied
cell should not change when interrogated by that tool.

As for the 'manage' dialog, it appears that if you have thousands of
conditions, the manage dialog could become unmanageable.  Maybe that's the
motivation of the feature to group copied formats together.  However, that
should then also happen when the CF is created independently.

I'm therefore not seeing any way to query the conditional formatting state of a
single selected cell, without using the manage dialog that will show it for all
cells.  Am I missing that?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200521/be507075/attachment-0001.htm>