<html>
<head>
<base href="https://bugs.freedesktop.org/" />
</head>
<body><span class="vcard"><a class="email" href="mailto:squeezechart@gmx.de" title="squeezechart@gmx.de">squeezechart@gmx.de</a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW --- - LibreOffice 4.2 most annoying bugs"
href="https://bugs.freedesktop.org/show_bug.cgi?id=65675">bug 65675</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;">Depends on</td>
<td>
</td>
<td>65074
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW --- - LibreOffice 4.2 most annoying bugs"
href="https://bugs.freedesktop.org/show_bug.cgi?id=65675#c73">Comment # 73</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW --- - LibreOffice 4.2 most annoying bugs"
href="https://bugs.freedesktop.org/show_bug.cgi?id=65675">bug 65675</a>
from <span class="vcard"><a class="email" href="mailto:squeezechart@gmx.de" title="squeezechart@gmx.de">squeezechart@gmx.de</a>
</span></b>
<pre>please add #65074
_____________________________________________________________________________
bug is not entirely fixed in LibreOffice 4.2
_____________________________________________________________________________
XLSX cells with 2 conditional formatting rules are not displayed correctly:
1. p.ex. cell values =$H$13:$H$427 have a color scale
2. cell values equal or smaller than =MIN(H$13:H$428)*1,1 should be bold
(Arial unicode, size 10)
In LibreOffice 4.2 the second rule is bold but wrong font and not changeable
Spreadsheet can be downloaded here:
<a href="http://www.squeezechart.com/SqueezeChart2013-preview.xlsx">http://www.squeezechart.com/SqueezeChart2013-preview.xlsx</a>
_____________________________________________________________________________
Behavior before LibreOffice 4.2:
_____________________________________________________________________________
cells with with conditional formatting sometimes show the numbers not centered
and without points; cell borders are not shown (see for example I13 to I21..)
Steps to reproduce:
Spreadsheet can be downloaded here:
<a href="http://www.squeezechart.com/SqueezeChart2013-preview.xlsx">http://www.squeezechart.com/SqueezeChart2013-preview.xlsx</a>
screenshot from Excel:
<a href="http://www.squeezechart.com/spreadsheet-in-Excel-15.0.4420.png">http://www.squeezechart.com/spreadsheet-in-Excel-15.0.4420.png</a>
screenshot from LibreOffice:
<a href="http://www.squeezechart.com/spreadsheet-in-LibreOffice-4.0.0.1.png">http://www.squeezechart.com/spreadsheet-in-LibreOffice-4.0.0.1.png</a>
Current behavior:
cells with with conditional formatting sometimes show the numbers not centered
and without points; cell borders are not shown
Expected behavior:
All cells in the main table must contain centered numbers with thousand points.
Operating System: Windows 8
Version: 4.0.3.3 release</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are on the CC list for the bug.</li>
</ul>
</body>
</html>