https://bugs.documentfoundation.org/show_bug.cgi?id=172479
Bug ID: 172479
Summary: Function TEXTAFTER() does not match Excel365 results
with "match end", Interop issue
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The Excel365 formulas
=TEXTAFTER("apple-orange-banana"; "-"; 3; 0;0;"not found")
returns "not found".
(there is no 3rd instance of "-" -> catch error and display "not found")
=TEXTAFTER("apple-orange-banana"; "-"; 3; 0;1;"not found")
returns "" (empty string)
(there is no 3rd instance of "-" but returns silently, i.e. no error)
The Calc formulas
=TEXTAFTER("apple-orange-banana","-",3, 0,0,"not found")
returns "not found". OK!
=TEXTAFTER("apple-orange-banana","-",3, 0,1,"not found")
returns "banana" NOT OK.
Should return empty string "" for interop sake.
The 5th parameter is called "match end". It not very clear in the Help page of
LibreOffice TEXTAREA and not even in MS Support page.
Note: May affect TEXTBEFORE() as well.
--
You are receiving this mail because:
You are the assignee for the bug.
