[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

Michael Warner <michael.warner.ut+libreoffice at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #6 from Michael Warner <michael.warner.ut+libreoffice at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200810/cc6a4440/attachment-0001.htm>