Find Array Function Issue [Bug]

asked 2020-04-17 07:07:46 +0100

flywire
47 ●4 ●9 ●13

updated 2020-08-05 11:25:46 +0100

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

The wizard result is not given in the cell:

=FIND({"A";"B";"C"},"SAMPLE TEXT")

Getting #NAME? expecting {2;#VALUE!;#VALUE!}

image description

Then click OK

image description

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2020-04-17 08:14:43 +0100

Mike Kaganski

17134 ●12 ●71 ●167 https://www.collaborao...

This is not a function issue, this is function wizard issue. Entering the formula in formula bar, and using Shift+Ctrl+Enter to complete it, makes it work as expected. You are welcome to file a bug report.

edit flag offensive delete link

Comments

https://bugs.documentfoundation.org/s...

flywire ( 2020-04-17 09:44:10 +0100 )edit

Could someone confirm that bug?

flywire ( 2020-05-02 05:55:42 +0100 )edit

Fixed for 6.4.5

erAck ( 2020-05-13 13:15:53 +0100 )edit

add a comment

Question Tools

1 follower

Stats

Asked: 2020-04-17 07:07:46 +0100

Seen: 75 times

Last updated: Apr 18 '20

Find Array Function Issue [Bug] edit

1 Answer

Comments

Question Tools

Stats

Related questions

Find Array Function Issue [Bug]