<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 - LibreOffice Calc sorts incorrectly (EDITING)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141936">141936</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOffice Calc sorts incorrectly (EDITING)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.3.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</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>ozsolarwind@iinet.net.au
</td>
</tr></table>
<p>
<div>
<pre>Description:
When sorting (Data -> Sort...) by a single column Calc incorrectly orders other
columns.
Steps to Reproduce:
1. Sort the attached spreadsheet by Station Name.
2. Values in the Latitude and Longitude columns sort incorrectly
3.
Actual Results:
Station Name Technology Latitude Longitude
wind_-28.0000-114.3750 Wind -32 115.625
wind_-28.5000-114.3750 Wind -28.5 114.375
wind_-29.0000-115.0000 Wind -33 115.625
wind_-30.5000-115.0000 Wind -30 115
wind_-31.0000-115.6250 Wind -28 115
wind_-31.5000-115.6250 Wind -34 115.625
wind_-32.5000-115.6250 Wind -28.5 115
wind_-33.5000-115.0000 Wind -33.5 115
wind_-33.5000-115.6250 Wind -28 114.375
wind_-34.0000-115.0000 Wind -34 115
wind_-34.0000-115.6250 Wind -29 115
wind_-34.5000-115.0000 Wind -34.5 115
wind_-34.5000-115.6250 Wind -34.5 115.625
wind_-34.5000-116.2500 Wind -32.5 115.625
wind_-34.5000-118.7500 Wind -30.5 115
wind_-34.5000-119.3750 Wind -34.5 119.375
wind_-35.0000-116.2500 Wind -35 116.25
wind_-35.0000-116.8750 Wind -35 116.875
wind_-35.0000-117.5000 Wind -35 117.5
wind_-35.0000-118.1250 Wind -35 118.125
Expected Results:
Station Name Technology Latitude Longitude
wind_-28.0000-114.3750 Wind -28 114.375
wind_-28.5000-114.3750 Wind -28.5 114.375
wind_-29.0000-115.0000 Wind -29 115
wind_-30.5000-115.0000 Wind -30.5 115
wind_-31.0000-115.6250 Wind -31 115.625
wind_-31.5000-115.6250 Wind -31.5 115.625
wind_-32.5000-115.6250 Wind -32.5 115.625
wind_-33.5000-115.0000 Wind -33.5 115
wind_-33.5000-115.6250 Wind -33.5 115.625
wind_-34.0000-115.0000 Wind -34 115
wind_-34.0000-115.6250 Wind -34 115.625
wind_-34.5000-115.0000 Wind -34.5 115
wind_-34.5000-115.6250 Wind -34.5 115.625
wind_-34.5000-116.2500 Wind -34.5 116.25
wind_-34.5000-118.7500 Wind -34.5 118.75
wind_-34.5000-119.3750 Wind -34.5 119.375
wind_-35.0000-116.2500 Wind -35 116.25
wind_-35.0000-116.8750 Wind -35 116.875
wind_-35.0000-117.5000 Wind -35 117.5
wind_-35.0000-118.1250 Wind -35 118.125
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 2; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.3-0ubuntu0.20.10.1
Calc: threaded</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>