Phpspreadsheet: Tables, lists and names get lost in the process

[seabasss]

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?

To load an excel file and the same file comes out with tables, dropdown lists and defined names

What is the current behavior?

PhpSpreadsheet strips tables, dropdown lists and defined names and can't reach ranges from other sheets

What are the steps to reproduce?

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load("template.xlsx");

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="result.xlsx"');
header('Cache-Control: max-age=0');

$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');
exit;

You need to load my Excel file and run it through for a complete example, which I can provide if needed. Here are two screenshots of before and after PhpSpreadsheet though:

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet: v1.6.0
PHP: v7.1.23

Edit // Any news on this?

[seabasss]

Bump. Thank you!

[stale[bot]]

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.

[landall]

Will the feature be supported in the future?

[seabasss]

Wondering too. Thanks!

[udacityanna]

If your company needs to meet accessibility standards, this problem is important.

[cbepxpa3ym]

This issue is still active. Any plans to fix it?

[carloslabrador]

Do you know anything about this?

[seabasss]

Any news on this? Thanks!