https://bugs.documentfoundation.org/show_bug.cgi?id=146915
Bug ID: 146915
Summary: LEFT and RIGHT functions inconsistent behaviour with
numerals
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 177699
--> https://bugs.documentfoundation.org/attachment.cgi?id=177699&action=edit
Simple calc sheet to demonstrate the inconsistency
Comparing the left hand (or right hand) digit of a number with a digit returns
a different result depending on the formula structure, even though both
structures are mathematically identical ie:
=A=B reports FALSE, whereas =A-B=0 reports TRUE
So in my spreadsheet:
=LEFT(B4)=A$2 reports FALSE (incorrectly) whereas
=LEFT(B4)-A$2=0 reports TRUE (correctly)
I presume it's associated with the function being designed for a string (and I
checked on the attached test sheet and letters work as expected) but the above
still suggests an inconsistency when dealing with numbers. I changed the
format of the numbers to text but it didn't alter the results
--
You are receiving this mail because:
You are the assignee for the bug.
