https://bugs.documentfoundation.org/show_bug.cgi?id=170383
Bug ID: 170383
Summary: LET Function: Cannot give array variable to FIND as
argument
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The following gives an error:
=LET( chars,{"A","B"}, upper,FIND(chars,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),
COLUMNS(upper)) .... error Err:504
But these 2 functions work:
=LET( chars,{"A","B"}, upper,FIND({"A","B"},"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),
COLUMNS(upper)) .... no error, result 2
=LET( chars,{"A","B"}, upper,FIND(chars,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),
COLUMNS(chars)) .... no error, result 2
Steps to Reproduce:
1. Enter the following function in a cell: =LET( chars,{"A","B"},
upper,FIND(chars,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"), COLUMNS(upper))
2. Result: Err:504 instead of 2
3. But the following 2 functions give the correct result of 2:
4. =LET( chars,{"A","B"}, upper,FIND({"A","B"},"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),
COLUMNS(upper))
5. =LET( chars,{"A","B"}, upper,FIND(chars,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),
COLUMNS(chars))
3.
Actual Results:
see above
Expected Results:
see above
Reproducible: Always
User Profile Reset: No
Additional Info:
no other info
--
You are receiving this mail because:
You are the assignee for the bug.
