https://bugs.documentfoundation.org/show_bug.cgi?id=145070
Bug ID: 145070
Summary: Formula IF & LEFT(RIGHT) conflict
Product: LibreOffice
Version: 7.1.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Formula Editor
Assignee: [email protected]
Reporter: [email protected]
Description:
IF
A1=10.5G，A2=10.2C
=IF(LEFT(A1,4)>LEFT(A2,3))=True
A1=10.5G，A2=9.7C
=IF(LEFT(A1,4)>LEFT(A2,3))=False
It seems that difference of number of characters would make formula IF & LEFT
go wrong, and formula RIGHT is as well.
Steps to Reproduce:
1. Assume A1=10.5G，A2=9.7C
2. Formula IF(LEFT(A1,4)>LEFT(A2,3))=False
3.
Actual Results:
FALSE
Expected Results:
TRUE
Reproducible: Always
User Profile Reset: No
Additional Info:
please check the formula IF & LEFT
--
You are receiving this mail because:
You are the assignee for the bug.
