FM / Cell

/home/techb158/immovalet.com/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/

/home/techb158/immovalet.com/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell

Name	Size	Mode	Actions
AddressHelper.php	5826	0644	edit dl rm
AdvancedValueBinder.php	8075	0644	edit dl rm
Cell.php	17053	0644	edit dl rm
Coordinate.php	19511	0644	edit dl rm
DataType.php	2041	0644	edit dl rm
DataValidation.php	8049	0644	edit dl rm
DataValidator.php	2193	0644	edit dl rm
DefaultValueBinder.php	2642	0644	edit dl rm
Hyperlink.php	1872	0644	edit dl rm
IValueBinder.php	302	0644	edit dl rm
StringValueBinder.php	636	0644	edit dl rm

Edit: /home/techb158/immovalet.com/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/DataType.php (2041B)

<?php

namespace PhpOffice\PhpSpreadsheet\Cell;

use PhpOffice\PhpSpreadsheet\RichText\RichText;
use PhpOffice\PhpSpreadsheet\Shared\StringHelper;

class DataType
{
    // Data types
    const TYPE_STRING2 = 'str';
    const TYPE_STRING = 's';
    const TYPE_FORMULA = 'f';
    const TYPE_NUMERIC = 'n';
    const TYPE_BOOL = 'b';
    const TYPE_NULL = 'null';
    const TYPE_INLINE = 'inlineStr';
    const TYPE_ERROR = 'e';

/**
     * List of error codes.
     *
     * @var array
     */
    private static $errorCodes = [
        '#NULL!' => 0,
        '#DIV/0!' => 1,
        '#VALUE!' => 2,
        '#REF!' => 3,
        '#NAME?' => 4,
        '#NUM!' => 5,
        '#N/A' => 6,
    ];

/**
     * Get list of error codes.
     *
     * @return array
     */
    public static function getErrorCodes()
    {
        return self::$errorCodes;
    }

/**
     * Check a string that it satisfies Excel requirements.
     *
     * @param null|RichText|string $pValue Value to sanitize to an Excel string
     *
     * @return null|RichText|string Sanitized value
     */
    public static function checkString($pValue)
    {
        if ($pValue instanceof RichText) {
            // TODO: Sanitize Rich-Text string (max. character count is 32,767)
            return $pValue;
        }

// string must never be longer than 32,767 characters, truncate if necessary
        $pValue = StringHelper::substring($pValue, 0, 32767);

// we require that newline is represented as "\n" in core, not as "\r\n" or "\r"
        $pValue = str_replace(["\r\n", "\r"], "\n", $pValue);

return $pValue;
    }

/**
     * Check a value that it is a valid error code.
     *
     * @param mixed $pValue Value to sanitize to an Excel error code
     *
     * @return string Sanitized value
     */
    public static function checkErrorCode($pValue)
    {
        $pValue = (string) $pValue;

if (!isset(self::$errorCodes[$pValue])) {
            $pValue = '#NULL!';
        }

return $pValue;
    }
}

0, '#DIV/0!' => 1, '#VALUE!' => 2, '#REF!' => 3, '#NAME?' => 4, '#NUM!' => 5, '#N/A' => 6, ]; /** * Get list of error codes. * * @return array */ public static function getErrorCodes() { return self::$errorCodes; } /** * Check a string that it satisfies Excel requirements. * * @param null|RichText|string $pValue Value to sanitize to an Excel string * * @return null|RichText|string Sanitized value */ public static function checkString($pValue) { if ($pValue instanceof RichText) { // TODO: Sanitize Rich-Text string (max. character count is 32,767) return $pValue; } // string must never be longer than 32,767 characters, truncate if necessary $pValue = StringHelper::substring($pValue, 0, 32767); // we require that newline is represented as "\n" in core, not as "\r\n" or "\r" $pValue = str_replace(["\r\n", "\r"], "\n", $pValue); return $pValue; } /** * Check a value that it is a valid error code. * * @param mixed $pValue Value to sanitize to an Excel error code * * @return string Sanitized value */ public static function checkErrorCode($pValue) { $pValue = (string) $pValue; if (!isset(self::$errorCodes[$pValue])) { $pValue = '#NULL!'; } return $pValue; } }