Find Array Function Issue [Bug]
The wizard result is not given in the cell:
=FIND({"A";"B";"C"},"SAMPLE TEXT")
Getting #NAME? expecting {2;#VALUE!;#VALUE!}
Then click OK
First time here? Check out the FAQ!
The wizard result is not given in the cell:
=FIND({"A";"B";"C"},"SAMPLE TEXT")
Getting #NAME? expecting {2;#VALUE!;#VALUE!}
Then click OK
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.
Asked: 2020-04-17 07:07:46 +0100
Seen: 75 times
Last updated: Apr 18 '20
Is there a polynomial curve fit function(s) in Calc ? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]