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: libreoffice-bugs@lists.freedesktop.org Reporter: reedie1...@gmail.com 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.