<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 - Merged Cells adopt the format of the first cell instead of the cell with contents"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138082">138082</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Merged Cells adopt the format of the first cell instead of the cell with contents
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.6.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>minor
</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>that.man.colin@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Version: 6.4.6.2 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: default; VCL: win;
Locale: sv-SE (en_GB); UI-Language: en-GB
Calc: threaded
If a small array of say three horizontal cells contains formatted data ONLY in
the centre cell then selecting the two adjacent cells to [Merge & Centre Cells]
with the "filled" cell adopts the format of the first cell in the selected
range and ignores the format implied by the only data contained in the selected
range.
1 Type in any empty cell "Lucida 16pt"
2 Select that cell and change the format to Lucida Handwriting 16pt
3 Select the range including the adjacent cell on either side and [Merge &
Centre Cells]
4 Observe that the format reverts to whatever is the format of the first cell
in the range
5 With the range selected, access the font menu with the down chevron and the
Lucida font will magically identify itself as the cell format and the displayed
format will change to Lucida - but only until the chevron is released
6 Expunge the [Merge & Centre Cells] format and the contents jump into the
first cell of the range and revert to default format.
The same effect is apparent with a vertically adjacent range of cells.
The same effect is apparent if the "filled" cell is at either extremity of the
[Merge & Centre Cells] range
If two cells contain data then the merge rules are handled correctly BUT all
cells will adopt the "first cell" format. This is the Dichotomy - How should
two alternate formats be treated? It's only a conundrum if more than two
formats exist ;)))</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>