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

[bugzilla-daemon]

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

Michael Warner  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |NOTABUG

--- Comment #6 from Michael Warner  ---
It seems to me the reason you are getting #VALUE! in the O column, is because
the range given to the min() formula contains the J column, which also has
#VALUE!. The #VALUE! in the J column, is due to an arithmetic formula like
this:
=20/I172*100

Where the corresponding cell in the I column has text. So, Calc is trying to
find, for example, '20/nėra pozicijos*100' and getting an error. 

This all looks like expected behavior to me.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Kęstutis Snieška  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  ---
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs