Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/ -> ExcelMatch.php (source)

[Source view]

Differences Between: [Versions 400 and 401] [Versions 401 and 402] [Versions 401 and 403]

(no description)

File Size: 203 lines (8 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

ExcelMatch:: (8 methods):
  MATCH()
  matchFirstValue()
  matchLargestValue()
  matchSmallestValue()
  validateLookupValue()
  validateMatchType()
  validateLookupArray()
  prepareLookupArray()


Class: ExcelMatch  - X-Ref

MATCH($lookupValue, $lookupArray, $matchType = self::MATCHTYPE_LARGEST_VALUE)   X-Ref
MATCH.

The MATCH function searches for a specified item in a range of cells

Excel Function:
=MATCH(lookup_value, lookup_array, [match_type])

param: mixed $lookupValue The value that you want to match in lookup_array
param: mixed $lookupArray The range of cells being searched
param: mixed $matchType The number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below.
return: array|int|string The relative position of the found item

matchFirstValue($lookupArray, $lookupValue)   X-Ref
No description

matchLargestValue($lookupArray, $lookupValue, $keySet)   X-Ref
No description

matchSmallestValue($lookupArray, $lookupValue)   X-Ref
No description

validateLookupValue($lookupValue)   X-Ref
No description

validateMatchType($matchType)   X-Ref
No description

validateLookupArray($lookupArray)   X-Ref
No description

prepareLookupArray($lookupArray, $matchType)   X-Ref
No description