[Libreoffice-bugs] [Bug 135551] =min() intolerance to text in fields

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135551

Kęstutis Snieška <kestutis.snieska at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|=min() wrong results and    |=min() intolerance to text
                   |intolerance to text in      |in fields
                   |fields                      |

--- Comment #5 from Kęstutis Snieška <kestutis.snieska at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200810/8f90e06d/attachment.htm>