https://bugs.documentfoundation.org/show_bug.cgi?id=146630
Bug ID: 146630
Summary: Error for using a Mathematical function overrides OR
logic
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Say, I used the formula =OR(ROUND(B1,2)=1,B1=""). In this case the value of
cell B1 is a null string or "" returned by another formula. This results in the
ROUND portion of the formula to return a #VALUE error, but the other portion to
return TRUE. So, the output of the OR function should be TRUE. But instead, in
this case, the error overrides the logic and the formula returns a #VALUE
error.
Steps to Reproduce:
1. Write a formula in a cell that returns an error.
2. Write a formula in a cell that returns TRUE.
3. Write an OR function with the input of the cell that returned an error and
the cell that returned TRUE.
Actual Results:
#VALUE
Expected Results:
TRUE
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.2.4.1 (x64) / LibreOffice Community
--
You are receiving this mail because:
You are the assignee for the bug.
