https://bugs.documentfoundation.org/show_bug.cgi?id=147024
Bug ID: 147024
Summary: Inconsistent behavior of RIGHT() text function when
separating names to Firstname & Lastname
Product: LibreOffice
Version: 6.4 all versions
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 177849
--> https://bugs.documentfoundation.org/attachment.cgi?id=177849&action=edit
Test sheet demonstrating wrong behavior of CALC RIGHT() function.
I received a spreadsheet from a colleague in which Column A contained both the
first and last names of individuals. I needed to separate them into FirstName
and LastName columns.
In order to separate them, I entered the formulas LEFT(A#,FIND(" ",A#)) and
RIGHT(A#,(FIND(" ",A#)-1)) where # is the actual row number.
The LEFT() function always works as expected. Not so with RIGHT() function.
See the attached test sheet, especially rows 12-16.
This behavior also exists in Apache OpenOffice 4.6/4.10 and I found it on three
different computers using either Windows 7 or Linux Mint 20.1/20.2. AOO and LO
are NOT simultaneously installed on any of these computers. The computers are
a mixture of DELL Latitude E6510 laptops and Optiplex 9010 desktops.
--
You are receiving this mail because:
You are the assignee for the bug.
