Re: Possible Formula Bug in Calc? (IsError and Find)

Here is an example spreadsheet showing off the bug. After experimenting a bit today I can conclude there doesn't seem to be a single function that can capture the error from Find() when used in an array like this. Using the function wizard and moving the cursor through the formula on the lower c

RE: Possible Formula Bug in Calc? (IsError and Find)

I am not sure, but if you expect Find to return a number, try N(FIND(…)) instead – it converts value into a number. Howard From: ouch Sent: Tuesday, April 11, 2017 2:31 AM To: dev@openoffice.apache.org Subject: Possible Formula B

Re: Possible Formula Bug in Calc? (IsError and Find)

Hi, The purpose of FIND is to get the position of a substring in a longer string. What do you want to achieve? The use of FIND in an array function looks strange. Kind regards Regina ouch schrieb: I have an array formula that is returning an error of #VALUE when it shouldn't.The formula is

Possible Formula Bug in Calc? (IsError and Find)

I have an array formula that is returning an error of #VALUE when it shouldn't.The formula is below. {=ISERROR(INDEX($'Sales 4-10-2017'.$A$1:$A$1000;SMALL(IF(ISERROR(FIND("Discount";$'Sales 4-10-2017'.$A$1:$A$1000))=0;ROW($'Sales 4-10-2017'.$A$1:$A$1000);"");ROW(A200} Digging into it, it s