PhpSpreadsheet/tests/PhpSpreadsheetTests/Calculation/Functions/LookupRef
oleibman d27b6a672a
Cleanup 3 LookupRef Tests (#3097)
Scrutinizer had previously suggested annotations for 3 LookupRef tests, but it no longer accepts its own annotation for those cases. This PR cleans them up. ColumnsTest and RowsTest are extremely straightforward.

IndexTest is a bit more complicated, but only because, unlike the other two, it had no test which executed in the context of a spreadsheet. And, when I added those, I discovered a couple of bugs. INDEX always requires at least 2 parameters (row# is always required), but its entry in the function table specified 1-4 parameters, now changed to 2-4. And, omitting col# is not handled the same way as specifying 0 for col#, though the code had treated them identically. (The same would have been true for row# but, because it is now required, ...)
2022-10-01 07:05:54 -07:00
..
AddressInternationalTest.php R1C1 Format and Internationalization, plus Relative Offsets (#3052) 2022-09-16 08:25:26 -07:00
AddressTest.php R1C1 Format and Internationalization, plus Relative Offsets (#3052) 2022-09-16 08:25:26 -07:00
AllSetupTeardown.php Minor Improvement to Test Cleanup LookupRef 2021-05-14 10:30:49 +02:00
ChooseTest.php Start work on array-enabling the Lookup and Reference functions (#2602) 2022-02-19 18:36:50 +01:00
ColumnOnSpreadsheetTest.php Minor Improvement to Test Cleanup LookupRef 2021-05-14 10:30:49 +02:00
ColumnTest.php Replace Tests With Unneeded Mocking (#2465) 2021-12-31 13:24:43 -08:00
ColumnsOnSpreadsheetTest.php Minor Improvement to Test Cleanup LookupRef 2021-05-14 10:30:49 +02:00
ColumnsTest.php Cleanup 3 LookupRef Tests (#3097) 2022-10-01 07:05:54 -07:00
FilterTest.php Bugfix to returned column indexes for FILTER() by row 2022-03-24 22:12:08 +01:00
FormulaTextTest.php Sync composer.lock (#3075) 2022-09-20 08:37:00 -07:00
HLookupTest.php Bugfix for Issue #3013, Named ranges not usable as anchors in OFFSET function 2022-08-19 11:28:51 +02:00
HyperlinkTest.php Extract information functions (#2605) 2022-02-19 13:53:17 +01:00
IndexOnSpreadsheetTest.php Cleanup 3 LookupRef Tests (#3097) 2022-10-01 07:05:54 -07:00
IndexTest.php Cleanup 3 LookupRef Tests (#3097) 2022-10-01 07:05:54 -07:00
IndirectInternationalTest.php R1C1 Format and Internationalization, plus Relative Offsets (#3052) 2022-09-16 08:25:26 -07:00
IndirectTest.php R1C1 Format and Internationalization, plus Relative Offsets (#3052) 2022-09-16 08:25:26 -07:00
LookupTest.php Start work on array-enabling the Lookup and Reference functions (#2602) 2022-02-19 18:36:50 +01:00
MatchTest.php Start work on array-enabling the Lookup and Reference functions (#2602) 2022-02-19 18:36:50 +01:00
MatrixHelperFunctionsTest.php Initial work implementing the FILTER() Lookup/Reference function 2022-03-20 18:01:30 +01:00
MovedFunctionsTest.php Extract information functions (#2605) 2022-02-19 13:53:17 +01:00
OffsetTest.php Bugfix for Issue #3013, Named ranges not usable as anchors in OFFSET function 2022-08-19 11:28:51 +02:00
RowOnSpreadsheetTest.php Minor Improvement to Test Cleanup LookupRef 2021-05-14 10:30:49 +02:00
RowTest.php Replace Tests With Unneeded Mocking (#2465) 2021-12-31 13:24:43 -08:00
RowsOnSpreadsheetTest.php Minor Improvement to Test Cleanup LookupRef 2021-05-14 10:30:49 +02:00
RowsTest.php Cleanup 3 LookupRef Tests (#3097) 2022-10-01 07:05:54 -07:00
SortByTest.php Additional unit testing 2022-03-24 17:51:06 +01:00
SortTest.php Initial work on the SORT() and SORTBY() Lookup/Reference functions 2022-03-24 12:21:27 +01:00
TransposeTest.php Replace Tests With Unneeded Mocking (#2465) 2021-12-31 13:24:43 -08:00
UniqueTest.php Fix scrutinizer issue complaint 2022-03-18 15:07:13 +01:00
VLookupTest.php VLOOKUP Breaks When Array Contains Null Cells (#2939) 2022-07-17 06:27:56 -07:00