5 Commits

Author	SHA1	Message	Date
Adrien Crivelli	ec4098c8fd	Strict mode for all tests ... While we might never be able to have 100% of our code strict, we can at the very least do it for all of our tests. This ensures that our tests are using our API with the types as intended by the test author, and not silently be cast to what our API requires.	2023-09-07 17:44:56 +08:00
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