Skip to content
Permalink
Branch: master
Commits on Apr 15, 2019
  1. Fix VLOOKUP whose return was impacted by order for a $not_exact_match (

    frantzmiccoli authored and MarkBaker committed Apr 15, 2019
    …#854)
    
    * Highlight VLOOKUP bug with a new test
    
    * Remove useless statements + fix VLOOKUP bug
    
    Please not that we have still inconsistencies in Excel (See LOOKUP and
    VLOOKUP.php test files)
    
    * Base strtolower on our StringHelper in LookupRef
Commits on Mar 6, 2019
  1. Fix MATCH an error was appearing when comparing strings against 0 (al…

    frantzmiccoli authored and MarkBaker committed Mar 6, 2019
    …ways true) + making a return statement a bit more explicit (#855)
Commits on Dec 15, 2018
  1. Exact match in VLOOKUP now returns first match

    frantzmiccoli authored and PowerKiKi committed Dec 10, 2018
    It was inconsistent with spreadsheet software before.
    
    Closes #809
  2. Add tests for the LOOKUP function

    frantzmiccoli authored and PowerKiKi committed Dec 13, 2018
    We were performing operations to patch for missing $result_vector
    even when one was defined, this was causing bugs on edge cases.
    
    Fixes #796
    Closes #816
You can’t perform that action at this time.