<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Clear Direct Formatting removes Conditional Formatting"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122697">122697</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Clear Direct Formatting removes Conditional Formatting
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>prusselltechgroup@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Clear Direct Formatting removes Conditional Formatting.
Conditional Format itself is deleted when entire spreadsheet is selected.
Steps to Reproduce:
1. Create a spreadsheet with Conditional Formatting (i.e., change background
for odd rows) for the range A2:E9
2. Right-click E5 and select Clear Direct Formatting.
3. The Conditional Format will no longer appy to E5. Checking the conditional
format will show the range changed from A2:E9 to A2:D9,E2:E4,E6:E9.
Please see attached sample spreadsheet and image.
Actual Results:
Conditional Format is removed.
If the entire spreadsheet is selected and Clear Direct Formatting is selected,
the Conditional Format itself will be deleted.
Expected Results:
Conditional Format is not removed. The range stays the same.
The Conditional Format itself is NOT deleted.
Reproducible: Always
User Profile Reset: No
Additional Info:
>From the Help:
Clear Direct Formatting
Removes direct formatting and formatting by character styles from the
selection.
Direct formatting is formatting that you applied without using styles, such as
setting bold typeface by clicking the Bold icon.</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>