https://bugs.documentfoundation.org/show_bug.cgi?id=121575
--- Comment #7 from Mike Kaganski <mikekagan...@hotmail.com> ---
(In reply to Mario Cataldi from comment #6)
The syntax for Calc operators is described in help:
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060199.html. You may
see that there's no ternary A<B<C operators exist, so you have to use
equivalents using AND() and such spreadsheet functions. There is no 1:1
correspondence between standard math notation and Calc syntax.
So yes, "1<Value<1.5" returns something other than you would expect - see
Eike's answer.
--
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
