Find Array Function Issue [Bug]

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

flywire
49 ●7 ●11 ●15

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

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

21584 ●22 ●61 ●60 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 +0200

Mike Kaganski

18330 ●12 ●74 ●174 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 +0200 )edit

Could someone confirm that bug?

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

Fixed for 6.4.5

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

add a comment

Question Tools

1 follower

Stats

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

Seen: 82 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]