<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:kestutis.snieska@gmail.com" title="Kęstutis Snieška <kestutis.snieska@gmail.com>"> <span class="fn">Kęstutis Snieška</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - =min() intolerance to text in fields"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135551">bug 135551</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;">Summary</td>
<td>=min() wrong results and intolerance to text in fields
</td>
<td>=min() intolerance to text in fields
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - =min() intolerance to text in fields"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135551#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - =min() intolerance to text in fields"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135551">bug 135551</a>
from <span class="vcard"><a class="email" href="mailto:kestutis.snieska@gmail.com" title="Kęstutis Snieška <kestutis.snieska@gmail.com>"> <span class="fn">Kęstutis Snieška</span></a>
</span></b>
<pre>The mistery of strange values is solved (J column was hidden, but the values
was taken from it) (it is still hidden in the attached document):
My Idea was as =min() is broken, probably =max() will be also. So I tried to
apply it to the O colum and saw many huge values appearing (not visible at
first). Then I noticed, that one column is missing, and made it appear. Now it
is clear, where it came from. It also explains, how it got transfered to Google
sheets and have the same behaviour.
What's still a mistery, that functions =МИН(), =МИНА(), =МАКС(), =МАКСА()
are "freaking" at text in cells in the range they are applied to.</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>