I have a worksheet with several functions, referring to other worksheets. The worksheet works perfectly in Excel. When loaded in Gembox Spreadsheets and calling the Caculate-method, the Value of the (as far as I can see) all cells change into “#N/A”.
Does anyone know to to get an actual value? Where can I see an actual error?
*** EDIT ***
I discovered that the VLOOKUP-function (with range_lookup set to false, so doing an exact math) is not functioning as it should. The range we are looking in is “A:C” (so complete columns, including the headers) and not A2:C99 (excluding the headers). Since we do an exact math this should work.