{"record":{"id":"f995d9fe01632dc7","repo":"PHPOffice/PhpSpreadsheet","slug":"value-f995d9","errorCode":"#VALUE!","errorMessage":"#VALUE!","messagePattern":"#VALUE!","errorType":"error_code","errorClass":"PhpOffice\\PhpSpreadsheet\\Calculation\\Exception","httpStatus":null,"severity":"error","filePath":"src/PhpSpreadsheet/Calculation/Engineering/EngineeringValidations.php","lineNumber":13,"sourceCode":"<?php\n\nnamespace PhpOffice\\PhpSpreadsheet\\Calculation\\Engineering;\n\nuse PhpOffice\\PhpSpreadsheet\\Calculation\\Exception;\nuse PhpOffice\\PhpSpreadsheet\\Calculation\\Information\\ExcelError;\n\nclass EngineeringValidations\n{\n    public static function validateFloat(mixed $value): float\n    {\n        if (!is_numeric($value)) {\n            throw new Exception(ExcelError::VALUE());\n        }\n\n        return (float) $value;\n    }\n\n    public static function validateInt(mixed $value): int\n    {\n        if (!is_numeric($value)) {\n            throw new Exception(ExcelError::VALUE());\n        }\n\n        return (int) floor((float) $value);\n    }\n}\n","sourceCodeStart":1,"sourceCodeEnd":28,"githubUrl":"https://github.com/PHPOffice/PhpSpreadsheet/blob/65b080eef4d9fd11a5796135ab145883e5c3d6a6/src/PhpSpreadsheet/Calculation/Engineering/EngineeringValidations.php#L1-L28","documentation":"Error \"#VALUE!\" thrown in PHPOffice/PhpSpreadsheet.","triggerScenarios":"Thrown at src/PhpSpreadsheet/Calculation/Engineering/EngineeringValidations.php:13 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"65b080eef4d9fd11a5796135ab145883e5c3d6a6","analyzedAt":"2026-08-17T05:40:41.646Z","schemaVersion":2},"datasetVersion":"2026-08-17T09:17:11.063Z"}