<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:heiko.tietze@documentfoundation.org" title="Heiko Tietze <heiko.tietze@documentfoundation.org>"> <span class="fn">Heiko Tietze</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: format and formula removed when merging formatted with non-formatted cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89951">bug 89951</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>enhancement
</td>
</tr>
<tr>
<td style="text-align:right;">Keywords</td>
<td>needsUXEval
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>libreoffice-ux-advise@lists.freedesktop.org
</td>
<td>heiko.tietze@documentfoundation.org
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: format and formula removed when merging formatted with non-formatted cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89951#c18">Comment # 18</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: format and formula removed when merging formatted with non-formatted cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=89951">bug 89951</a>
from <span class="vcard"><a class="email" href="mailto:heiko.tietze@documentfoundation.org" title="Heiko Tietze <heiko.tietze@documentfoundation.org>"> <span class="fn">Heiko Tietze</span></a>
</span></b>
<pre>Excel takes the format of the first non-empty cell into the merged cell. No
question or confirmation what to pick. For sake of familiarity we could do the
same. But we have to store the cell formattings in case the user un-merges
later, which Excel cannot.
<green><yellow><red> => <green>
<><yellow><red> => <> (no format)
<green><yellow>123<red>456 => <yellow>123
<green><>123<red>456 => <>123 (no format)
(IMHO not highly important)</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>