SimpleXMLElement::addChild(): unterminated entity reference "Col")),1)

[zappzerapp]

This is:

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

What is the expected behavior?

Read the xlsx file with multiple sheets and dropdown-values, also with formulas including quotations

What is the current behavior?

ErrorException
SimpleXMLElement::addChild(): unterminated entity reference "Col")),1)
vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Xlsx.php:938

What are the steps to reproduce?

<?php

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

$file = __DIR__ . DIRECTORY_SEPARATOR . 'reproduce.xlsx';
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReaderForFile($file);
$spreadsheet = $reader->load($file);

➜ reproduce.xlsx

What features do you think are causing the issue

• Reader
• Writer
• Styles
• Data Validations
• Formula Calculations
• Charts
• AutoFilter
• Form Elements

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

XSLX

Which versions of PhpSpreadsheet and PHP are affected?

• 1.25.2
• master

[oleibman]

Closing. Should be fixed by PR #3146.