https://bugs.freedesktop.org/show_bug.cgi?id=60671
Priority: medium
Bug ID: 60671
Assignee: [email protected]
Summary: Compound two-argument relation expressions calculated
as abbevaition for AND
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 74618
--> https://bugs.freedesktop.org/attachment.cgi?id=74618&action=edit
LO 4 evaluates compound inequalities differently to another versions of
software
Tradionally, in spreadsheets formulae expressions like a < b < c are evaluated
as a < (b < c) with implicit bool to int typecast. As a result, 10 < 11 < 12 is
expected to return FALSE.
In LO 4, however, the result is TRUE, like it was an abbrevation for (10<11)
AND (11<12). This is another syntax, known from a lot of languages, but its
introduction at user's level to spreadsheet is unexpected and undocumented.
The attachment illustrates the problem.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
