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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu May 21 19:39:15 UTC 2020


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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO
                 CC|                            |ming.v.hua at qq.com

--- Comment #2 from Ming Hua <ming.v.hua at qq.com> ---
I think I know what you mean, but I need clarification:

(In reply to pb from comment #0)
> Steps to Reproduce:
> New spreadsheet.
> Create a condition in say cell e5 using condition tool, for example if =1,
> make it yellow.
> Condition works.
> Re-opening conditional formatting dialog shows the expected condition and
> result.
What exactly do you mean by "Re-opening conditional formatting dialog"?  If I
choose menu Format > Conditional > Condition..., a dialog pops up asking me if
I want to edit the existing conditional format.  Clicking Yes gets me back to
the same dialog used for creating the conditional format.

On the other hand, there is the Format > Conditional > Manage... dialog, which
is different.

> Copy cell e5.
> Paste special formats only into cell c5.
> Reopen conditional formatting dialog for cell e5.  It now shows no format.
> Test whether e5 conditional formatting still works.  It does.
> Test whether c5 conditional formatting works.  It does.
> Open conditional formatting dialog for cell e5.  It now shows no format.
> Open conditional formatting dialog for cell c5.  It shows no format.
If your answer to my previous question is the same dialog after clicking yes,
then you want to try reopening the dialog while both C5 and E5 are selected
(hold Ctrl key while clicking them with mouse), this way the condition (equals
to 5) is correctly displayed.

-- 
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/bbfdbed6/attachment.htm>


More information about the Libreoffice-bugs mailing list