Exception: You must specify a worksheet or a scope for a Named Range

This is a bug report

What is the expected behavior?

Read an xlsx file of approximately 47000 rows.
sat.xlsx

What is the current behavior?

error 1

error 2

What are the steps to reproduce?

<?php
# error 1
require_once("vendor/autoload.php");
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
$reader = new Xlsx();
$reader->load("sat.xlsx");
?>

<?php
# error 2
require_once("vendor/autoload.php");
$file_type = null;
$reader = null;
$spreadsheet = null;
$data = null;
$rutaArchivo = "sat.xlsx";
$libro = 0;
$file_type = PhpOffice\PhpSpreadsheet\IOFactory::identify($rutaArchivo);
$reader = PhpOffice\PhpSpreadsheet\IOFactory::createReader($file_type);
$isReadDataOnly = $reader -> getreadDataOnly();
$spreadsheet = $reader->load($rutaArchivo);
$data = $spreadsheet->getActiveSheet($libro)->toArray();
var_dump( count($data) );
die();
?>

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet 1.15.0.0
PHP 7.4.11

[alexxxxkkkk]

I have the same issue but only when filling the loadSheetsOnly array.

Example:

<?php

use PhpOffice\PhpSpreadsheet\IOFactory;

$reader = IOFactory::createReaderForFile('example.xlsx');

$reader->setLoadSheetsOnly(['Sheet 1', 'Sheet 2']);

$spreadsheet = $reader->load('example.xlsx');

It throws the error: "PhpOffice\PhpSpreadsheet\Exception: You must specify a worksheet or a scope for a Named Range" due to loading only specific sheets. (Xlsx file contains 3 sheets ('Sheet 1', 'Sheet 2', 'Sheet 3'))

PhpOffice\PhpSpreadsheet\Exception: You must specify a worksheet or a scope for a Named Range

vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/NamedRange.php:21
vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/DefinedName.php:97
vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Xlsx.php:1399

PhpSpreadsheet - 1.15.0