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

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

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

ible 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))=

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

2:31 AM To: dev@openoffice.apache.org Subject: 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";