<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:raymond.macdonald.smith@gmail.com" title="Raymond Smith <raymond.macdonald.smith@gmail.com>"> <span class="fn">Raymond Smith</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UI - Sort suppresses the first output data row when there are multiple heading lines and the sort is done on a column with concatenated headings"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142145">bug 142145</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;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UI - Sort suppresses the first output data row when there are multiple heading lines and the sort is done on a column with concatenated headings"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142145#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UI - Sort suppresses the first output data row when there are multiple heading lines and the sort is done on a column with concatenated headings"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142145">bug 142145</a>
from <span class="vcard"><a class="email" href="mailto:raymond.macdonald.smith@gmail.com" title="Raymond Smith <raymond.macdonald.smith@gmail.com>"> <span class="fn">Raymond Smith</span></a>
</span></b>
<pre>I used the following procedure with the input file (attached file 1) :
Verify the print-range settings:
- Print range: $A1:$K107
- Rows to repeat: $1:$2
- Columns to repeat: none
Select all (click on top left-hand cell)
Select Data->Sort
Select Options, and then select:
- case sensitive
- range contains column headings
- Direction: Top to bottom (sort rows)
Select Sort Criteria, and then specify:
- Sort Key 1: PREVIOUS 7-DAY AVERAGE ▲ (column I)
=> Descending
- Sort Key 2: COUNTRY (column F)
=> Ascending
The output file, incorrectly sorted, is attached (file 2)
When following the above procedure with Sort Key column J , the result is
correct (file 3)</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>