Spreadsheet getNamedRange returns null (1.5.0)

[shashane]

This is:

- [X] a bug report
- [ ] a feature request
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

Retriveing named ranges from xlsx file.

What is the current behavior?

namedRanges array in Spreadsheet object is empty

Works fine in 1.4.1.
Breaking change on 1.5.0.

What are the steps to reproduce?

<?php

require __DIR__ . '/vendor/autoload.php';

// Create new Spreadsheet object

$spreadsheet = IOFactory::load('My File.xlsx');
$range = $spreadsheet->getNamedRange('Range Name');
// 'My File.xlsx' contains a named range 'Range Name'
// $range is null
 

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet v1.5
Php 5.6.33

[guillaume-ro-fr]

I have exactly the same problem. Can you check if your worksheet title contains the ' character in your xlsx file for the defined named range ?

In debug mode, I found that extractSheetTitle don't works as expected :

Expected in the documentation :

extractSheetTitle("'testSheet 1'!A1", true) === ["testSheet 1", "A1"];

Actual :

extractSheetTitle("'testSheet 1'!A1", true) === ["'testSheet 1'",  "A1"];

The name in $pRange is for example 'Analyse du 1 Janvier 2018' and getTitle() return Analyse du 1 Janvier 2018.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[eigan]

See attached image from xdebug. PHPSpreadsheet is no longer able to get the proper Worksheet.

This started happening after we upgraded from 1.4.1 to 1.5.0 (same as OP)

Can we reopen this issue?

[eigan]

Stacktrace:

src/PhpSpreadsheet/Reader/Xlsx.php

[oleibman]

Appears to have been fixed in 09ab584 in August 2019.