Xlsx Reader Formula with quotePrefix caused huge regression in Xlsx reading performance

[paolobarbolini]

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?

I expect IOFactory::load($filename) to take a reasonable amount of time compared to IOFactory::load($filename, IReader::READ_DATA_ONLY).

What is the current behavior?

We have a file that starting from #3497 (1.29.0) takes up to 5x longer to load without IReader::READ_DATA_ONLY compared to not specifying any flags.

What are the steps to reproduce?

Put this file in the PHP directory: Reproducer.xlsx

<?php

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

$sheet = \PhpOffice\PhpSpreadsheet\IOFactory::load("Reproducer.xlsx" /*, \PhpOffice\PhpSpreadsheet\Reader\IReader::READ_DATA_ONLY */ );

Comment out

PhpSpreadsheet/src/PhpSpreadsheet/Style/Style.php

Line 685 in b879cdd

$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);

to fix the regression.

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?

.xlsx

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet 1.29.0
This has been tested on PHP 8.1.22 and PHP 8.2.9