<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Numerical cells with hyperlinks are sorted non-numerically"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132332">bug 132332</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;">Version</td>
<td>6.4.2.2 release
</td>
<td>6.2.8.2 release
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>ming.v.hua@qq.com
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Numerical cells with hyperlinks are sorted non-numerically"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132332#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Numerical cells with hyperlinks are sorted non-numerically"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132332">bug 132332</a>
from <span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span></b>
<pre>I can reproduce with 6.2.8 on Windows 10:
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win;
Locale: zh-CN (zh_CN); UI-Language: en-US
Calc: threaded
Steps:
1. Open the attached sample file;
2. Click in cell B1;
3. Data > Sort Descending (Sort Ascending works too, but it doesn't change the
current order of the cells);
4. Observe that row 2 to 72 are sorted, but all years with links are considered
larger than the ones without links.
Row 73 and higher are not sorted probably because B73 is empty and therefore
seen as the border of the auto-recognized region for sorting.</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>