PHPOffice/PhpSpreadsheet · error · PhpOffice\PhpSpreadsheet\Calculation\Exception

#VALUE!

#VALUE!

Error message

#VALUE!

What it means

Error "#VALUE!" thrown in PHPOffice/PhpSpreadsheet.

Source

Thrown at src/PhpSpreadsheet/Calculation/Financial/FinancialValidations.php:30

    public static function validateDate(mixed $date): float
    {
        return DateTimeExcel\Helpers::getDateValue($date);
    }

    public static function validateSettlementDate(mixed $settlement): float
    {
        return self::validateDate($settlement);
    }

    public static function validateMaturityDate(mixed $maturity): float
    {
        return self::validateDate($maturity);
    }

    public static function validateFloat(mixed $value): float
    {
        if (!is_numeric($value)) {
            throw new Exception(ExcelError::VALUE());
        }

        return (float) $value;
    }

    public static function validateInt(mixed $value): int
    {
        if (!is_numeric($value)) {
            throw new Exception(ExcelError::VALUE());
        }

        return (int) floor((float) $value);
    }

    public static function validateRate(mixed $rate): float
    {
        $rate = self::validateFloat($rate);
        if ($rate < 0.0) {

View on GitHub (pinned to 65b080eef4)

When it happens

Trigger: Thrown at src/PhpSpreadsheet/Calculation/Financial/FinancialValidations.php:30 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of PHPOffice/PhpSpreadsheet@65b080eef4 (2026-08-17). Data as JSON: /api/errors/1e9f8dce3a79436f. Report an issue: GitHub.