<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Calc conditional formatting condition dialog (ui) changes to no condition after copy: regression"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133242">bug 133242</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEEDINFO
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>ming.v.hua@qq.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Calc conditional formatting condition dialog (ui) changes to no condition after copy: regression"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133242#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Calc conditional formatting condition dialog (ui) changes to no condition after copy: regression"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133242">bug 133242</a>
from <span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span></b>
<pre>I think I know what you mean, but I need clarification:
(In reply to pb from <a href="show_bug.cgi?id=133242#c0">comment #0</a>)
<span class="quote">> 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.</span >
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.
<span class="quote">> 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.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>