<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Conditional formatting: false cell number format displayed that's defined by a cell style"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113307">bug 113307</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;">Severity</td>
<td>normal
</td>
<td>minor
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Conditional formatting: false cell number format displayed that's defined by a cell style"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113307#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Conditional formatting: false cell number format displayed that's defined by a cell style"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113307">bug 113307</a>
from <span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span></b>
<pre>I'm still not sure what is the exact bug here. We need to better explain it.
1. C2:D2 have CF:
- if cell value is INT(C2), apply style Whole numbers (it doesn't)
- if cell value is not INT(C2), apply style Decimal numbers (which it does for
C2 and D2, can be seen if Decimal numbers is red).
2. C2 cell value is 90,9 but instead of seing Decimal numbers (from CF) I guess
we see applied direct formatting that overrides style formatting (see Bug
93300) and that is Number with 0 decimal places.
3. What I don't understand is why D2 on fileopen shows Decimal numbers although
it has the same direct formatting as C2. Is it related to <a class="bz_bug_link
bz_status_NEW "
title="NEW - ODS mixes style with conditional formatting and direct formatting"
href="show_bug.cgi?id=114860">Bug 114860</a> or there's
some "perfectly logical explanation".
4. D2 has value of "4.90649064906491" and cached cell content of "5". Why does
it show 4,906 on fileopen? Why does it change to 5 on recalc or some change?
I guess there's the answer to the original bug report that 5 is pasted (similat
to what Thomas noted).
Since recalc changes view, I'll set to minor.
Different with OO 3.3 (90,9 and 5), LO 4.0 and LO 4.2 (90,9 and 4,906). Repro
6.0 and 6.3+ (91 and 4,906).</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>