ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / aficb.com / vendor / phpoffice / phpspreadsheet / src / PhpSpreadsheet / Calculation / LookupRef

<?php

namespace PhpOffice\PhpSpreadsheet\Calculation\LookupRef;

use PhpOffice\PhpSpreadsheet\Calculation\Exception;
use PhpOffice\PhpSpreadsheet\Calculation\Functions;

abstract class LookupBase
{
    protected static function validateIndexLookup($lookup_array, $index_number)
    {
        // index_number must be a number greater than or equal to 1
        if (!is_numeric($index_number) || $index_number < 1) {
            throw new Exception(Functions::VALUE());
        }

// index_number must be less than or equal to the number of columns in lookup_array
        if ((!is_array($lookup_array)) || (empty($lookup_array))) {
            throw new Exception(Functions::REF());
        }

return (int) $index_number;
    }

protected static function checkMatch(
        bool $bothNumeric,
        bool $bothNotNumeric,
        $notExactMatch,
        int $rowKey,
        string $cellDataLower,
        string $lookupLower,
        ?int $rowNumber
    ): ?int {
        // remember the last key, but only if datatypes match
        if ($bothNumeric || $bothNotNumeric) {
            // Spreadsheets software returns first exact match,
            // we have sorted and we might have broken key orders
            // we want the first one (by its initial index)
            if ($notExactMatch) {
                $rowNumber = $rowKey;
            } elseif (($cellDataLower == $lookupLower) && (($rowNumber === null) || ($rowKey < $rowNumber))) {
                $rowNumber = $rowKey;
            }
        }

return $rowNumber;
    }
}

[-] Hyperlink.php [edit]
[+] ..
[-] Address.php [edit]
[-] Indirect.php [edit]
[-] Selection.php [edit]
[-] Formula.php [edit]
[-] HLookup.php [edit]
[-] Offset.php [edit]
[-] LookupRefValidations.php [edit]
[-] Helpers.php [edit]
[-] LookupBase.php [edit]
[-] RowColumnInformation.php [edit]
[-] Lookup.php [edit]
[-] VLookup.php [edit]
[-] Matrix.php [edit]
[-] ExcelMatch.php [edit]