<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 - =min() wrong results and intelerance to text in fields"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135551">135551</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>=min() wrong results and intelerance to text in fields
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 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>kestutis.snieska@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
The cell in the O column is =min(HRowNumber:NRowNumber). The result for
DIN912 M10x240 and M10x260 are "out of space": arbitrary values, not any of the
values it is applied to.
The document is made with LibreCalc 6.4.5.2 on Windows 7 with Russian Locale
(the formula is entered in russian, originaly, but even if I open it on a
machine with english locale and correct it, it still misbehaves).
Interestingly, If import it to google sheets, it does misbihave there too. (I
have already reported it to google).
Here is the link to the .ods file:
<a href="https://drive.google.com/file/d/1ufnc-POvKPANO83aTZNaRvUZqLIpn1jX/view?usp=sharing">https://drive.google.com/file/d/1ufnc-POvKPANO83aTZNaRvUZqLIpn1jX/view?usp=sharing</a>
A bit older version of the spreadheet
(<a href="https://drive.google.com/file/d/1mzZmbnXj25-L2CDeP7au1UTlXUHBEA8O/view?usp=sharing">https://drive.google.com/file/d/1mzZmbnXj25-L2CDeP7au1UTlXUHBEA8O/view?usp=sharing</a>
,
does not exibit the error if I open it on another machine with
English/Lithuanian locale, do a colum inster and appy the formula(=min()).
Tested it with LibreOffice 6.3.6.2 (x64), Portable Apache OpenOffice 4.7 and
Google Calc).
Something is wrong with my LibreOffice, which does not like ascii strings in
cells using =min() : if the text is present, it shows error "#ЗНАЧ!" (#VALUE!).
If I delete the text, then it shows another error: "#ДЕЛ/0!
" (#DIV/0). Interestingly, that same document, when imported to google docs,
does behave the same: same mistakes, same strange values with the mentioned
strings.
Steps to Reproduce:
see the document (it misbehaves in the O column).
Actual Results:
1) =min and =mina is afraid of text cells
2) sometimes assigns strange values (totally non-existant in the selected
range).
Expected Results:
1) =min() ignores text cells
2) =min() assigns the minimum value of the range it applies to.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Версия: 6.4.5.2 (x86)
ID сборки: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
Потоков ЦП: 2; ОС: Windows 6.1 Service Pack 1 Build 7601; Отрисовка ИП: по
умолчанию; VCL: win;
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
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>