<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:kelemeng@ubuntu.com" title="Gabor Kelemen <kelemeng@ubuntu.com>"> <span class="fn">Gabor Kelemen</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Libre Calc is losing conditional formatting every day"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124788">bug 124788</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;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Libre Calc is losing conditional formatting every day"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124788#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Libre Calc is losing conditional formatting every day"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124788">bug 124788</a>
from <span class="vcard"><a class="email" href="mailto:kelemeng@ubuntu.com" title="Gabor Kelemen <kelemeng@ubuntu.com>"> <span class="fn">Gabor Kelemen</span></a>
</span></b>
<pre>(In reply to Oliver Brinzing from <a href="show_bug.cgi?id=124788#c3">comment #3</a>)
<span class="quote">> steps to reproduce with attached file:
>
> - Menu Format/Conditional/Manage...
> - select Z4:Z71
> - set Condition1: style "Good"
> - set Condition2: style "Bad"
> - save & reload
> - Menu Format/Conditional/Manage...
> - select Z4:Z71
> -> Condition1 changed: ConditionalStyle_3
> -> Condition2 changed: ConditionalStyle_4</span >
This is not a bug, but a feature. Or: conceptual difference.
Calc uses styles to conditionally format cells. Excel on the other hand uses
direct cell formatting.
On opening an XLSX file Calc takes the direct formatting of conditions and
converts it to ConditionalStyle_N styles.
And on saving it writes these implicit styles content as direct formatting to
XLSX.
So it is normal to see the style "Good" becoming "ConditionalStyle_3" - but
that's only the name: the font color and background color is retained and works
fine after opening in Excel too.</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>