Spreadsheet funtion not working properly

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • 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