<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 - Conditional formatting changes format of dates and numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108373">108373</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Conditional formatting changes format of dates and numbers
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>jbk4070@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have a sample ledger with columns B through H as Check No., Date, FirstName,
LastName, Income, Expense, and Balance. I want odd months to be shaded (light
blue). Date format: 6/6/17; numbers are all with 2 decimal places.
Conditional format using "=ISODD(MONTH($C6))" where C6 is the top date, makes
all odd month rows light blue BUT CHANGES THE FORMAT OF DATES to their date
number AND changes most whole numbers deleting their decimals (67.00 becomes
67, etc.)
I can change the number days between dates at will to help demonstrate the
problem.
This does not happen in Excel - I had to check!
Steps to Reproduce:
1.Removing the conditional formatting OR changing the difference in dates to
make more or fewer bands makes those dates changed to colorless (even months)
back to their normal date format, 06/06/17, etc. AND number regain their
decimal places!
2.
3.
Actual Results:
I'll be happy to email my sample sheet if you'll let me know how and where.
Expected Results:
See above. Dates should not change their format. Numbers also.
Reproducible: Always
User Profile Reset: No - - - and your instructions, below, do not work!
Additional Info:
I can't believe others haven't run into this problem!
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36</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>