Issue 31 in formulacompiler: vlookup does not handle results of mixed types

1 view

Skip to first unread message

formula...@googlecode.com

unread,

Sep 8, 2011, 10:58:32 AM9/8/11

to formulacom...@googlegroups.com

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 31 by Rube...@gmail.com: vlookup does not handle results of mixed
types
http://code.google.com/p/formulacompiler/issues/detail?id=31

What steps will reproduce the problem?
1. the attached xlsx file does not compile to java (use the CalcTest class
to verify)

What is the expected output? What do you see instead?
VLOOKUP to return an int

What version of the product are you using? On what operating system?
latest

Please provide any additional information below.
since the first row of the vlookup is a string it is assumed that all
results of the vlookup are strings. This is not always the case.