Spreadsheet funtion not working properly

    Spreadsheet funtion not working properly

    Hi there,

    i´m using the spreadfunction VLOOKUP in a PHP function that in return is used as user-defined spreadsheet function. The problem is, that it returns 0. The original spreadsheet function, with all the same parameters, returns the expected result though.

    Here´s the code:

    PHP Source Code

    1. $result = application()->vlookup($myValue, activeworkbook()->worksheets()->item($myRefSheet)->range('B5:C30'), 2, true);
    2. return $result;


    Result is 0 although the lookup range contains a corresponding value. Could this be a datatype problem between php and spreadsheet values?

    The core.log shows no macro_engine errors.

    Any suggestions would be appreciated

    cheers
    OMartin