{"record":{"id":"e560ca27d12476d0","repo":"PHPOffice/PhpSpreadsheet","slug":"3-d-range-references-are-not-supported","errorCode":null,"errorMessage":"3-D Range References are not supported","messagePattern":"3-D Range References are not supported","errorType":"exception","errorClass":"PhpOffice\\PhpSpreadsheet\\Exception","httpStatus":null,"severity":"error","filePath":"src/PhpSpreadsheet/Cell/Coordinate.php","lineNumber":497,"sourceCode":"                $base26 = self::LOOKUP_CACHE[$characterValue] . $base26;\n            } while ($indexValue > 0);\n            $indexCache[$columnIndex] = $base26;\n        }\n\n        return $indexCache[$columnIndex];\n    }\n\n    /**\n     * Extract all cell references in range, which may be comprised of multiple cell ranges.\n     *\n     * @param string $cellRange Range: e.g. 'A1' or 'A1:C10' or 'A1:E10,A20:E25' or 'A1:E5 C3:G7' or 'A1:C1,A3:C3 B1:C3'\n     *\n     * @return string[] Array containing single cell references\n     */\n    public static function extractAllCellReferencesInRange(string $cellRange): array\n    {\n        if (substr_count($cellRange, '!') > 1) {\n            throw new Exception('3-D Range References are not supported');\n        }\n\n        [$worksheet, $cellRange] = Worksheet::extractSheetTitle($cellRange, true);\n        $quoted = '';\n        if ($worksheet) {\n            $quoted = Worksheet::nameRequiresQuotes($worksheet) ? \"'\" : '';\n            if (str_starts_with($worksheet, \"'\") && str_ends_with($worksheet, \"'\")) {\n                $worksheet = substr($worksheet, 1, -1);\n            }\n            $worksheet = str_replace(\"'\", \"''\", $worksheet);\n        }\n        [$ranges, $operators] = self::getCellBlocksFromRangeString($cellRange ?? 'A1');\n\n        $cells = [];\n        foreach ($ranges as $range) {\n            /** @var string $range */\n            $cells[] = self::getReferencesForCellBlock($range);\n        }","sourceCodeStart":479,"sourceCodeEnd":515,"githubUrl":"https://github.com/PHPOffice/PhpSpreadsheet/blob/65b080eef4d9fd11a5796135ab145883e5c3d6a6/src/PhpSpreadsheet/Cell/Coordinate.php#L479-L515","documentation":"Error \"3-D Range References are not supported\" thrown in PHPOffice/PhpSpreadsheet.","triggerScenarios":"Thrown at src/PhpSpreadsheet/Cell/Coordinate.php:497 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"}