<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 - Calc gives wrong results"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120149">120149</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc gives wrong results
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</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>zieritz.andreas@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I've imported a text file to calc, changed the default decimal delimiter
settings, and tried to sort the list. Problem is that the listing is done
alphanumerical, not numerical (10, 100, 20 instead of 10, 20, 100).
Tried to find out what was going on and did some calculations.
90 / 10 = 9; 100 / 10 = 10
But 9 > 10 = false, 90 > 100 = true
Steps to Reproduce:
1. Open file
2. Check calculations in row N69
3.
Actual Results:
90 > 100 = TRUE
Expected Results:
90 > 100 = FALSE
Reproducible: Always
User Profile Reset: No
Additional Info:</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>