4 Commits

Author	SHA1	Message	Date
Mark Baker	70f372d88c	Start refactoring the Lookup and Reference functions (#1912) ... * Start refactoring the Lookup and Reference functions - COLUMN(), COLUMNS(), ROW() and ROWS() - LOOKUP(), VLOOKUP() and HLOOKUP() - Refactor TRANSPOSE() and ADDRESS() functions into their own classes * Additional unit tests - LOOKUP() - TRANSPOSE() - ADDRESS()	2021-03-10 21:18:33 +01:00
Adrien Crivelli	fcd9f10663	Update PHP-CS-Fixer rules	2020-05-18 13:49:57 +09:00
Fräntz Miccoli	ccebf0f288	Fix VLOOKUP whose return was impacted by order for a $not_exact_match (#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	2019-04-15 21:37:23 +02:00
Fräntz Miccoli	db2621c4fe	Add tests for the LOOKUP function ... 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	2018-12-15 16:23:45 +11:00