<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 - LibreOffice Calc does not apply conditional formatting as expected"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135246">135246</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOffice Calc does not apply conditional formatting as expected
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>FreeBSD
</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>byrnejb@harte-lyne.ca
</td>
</tr></table>
<p>
<div>
<pre>Description:
Fields possessing both direct and conditional formating have the direct
formatting removed (neumeric / data / currency) and replaced with the default
format. However the correct combined format is shown in the conditional format
dialogue box.
This is noted to occur erratically. Some cells have the display format
reverted and others do not.
Steps to Reproduce:
1. Open new sheet
2. Apply direct formatting to cell (date 2001-01-01)
3. Input new value in Cell
4. Apply negative warning conditional format to cell
5. Satisfy condition
6. Cell value changes from 2001-01-01 to 36892.00
Actual Results:
Cell displays 36892.00 in white on red background
Expected Results:
Cell should display 2001-01-01 in white on red background
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Not all conditionally formatted cells display this behaviour even when the same
conditions and conditional format applies.</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>