Error "Incorrect array size" When Using VLOOKUP Function with Unspecified Row Range

Tags: #<Tag:0x00007efc60a6ca08> #<Tag:0x00007efc60a6c788>
#1

Hi,
I’m encountering an issue with the HyperFormula engine while using the VLOOKUP function. Specifically, I receive an “Incorrect array size” error when the row range is not specified explicitly.

E.g.
=VLOOKUP(A1,sub1!A1:H1000,7,FALSE) - work
=VLOOKUP(A1,sub1!A:H,7,FALSE) - throw error

I found, that it happens because height is calculates as 0 in AbsoluteCellRange.ts (line 374).
effectiveHeight(dependencyGraph) {
return dependencyGraph.getSheetHeight(this.sheet);
}

ArraySize.js:15 Uncaught Error: Incorrect array size
at new ArraySize (ArraySize.js:15:1)
at new SimpleRangeValue (SimpleRangeValue.js:26:1)
at Function.onlyRange (SimpleRangeValue.js:57:1)
at Interpreter.evaluateAstWithoutPostprocessing (Interpreter.js:222:1)
at Interpreter.evaluateAst (Interpreter.js:48:1)
at LookupPlugin.evaluateAst (FunctionPlugin.js:130:1)
at FunctionPlugin.js:261:1
at Array.map ()
at LookupPlugin.evaluateArguments (FunctionPlugin.js:261:1)
at LookupPlugin.runFunction (FunctionPlugin.js:72:1)

I have tried:
・Updating Handsontable to the latest version
・Checking my formula syntax

Could anyone help me resolve this issue?
Thank you!

#2

Hi @z.li

Thank you for contacting us. Can you please share a code example in which the error can be replicated? That will help to determine the issue.

#3

Hi @z.li

I need to close this ticket, as it has been two weeks without any response.

If the issue is still replicable, please create a new thread or contact us at support@handsontable.com.

#4