XLSX Reader associated irrelevant quote prefixed style

[frantzmiccoli]

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?

Formula are correctly executed.

What is the current behavior?

Style is identified has being prefixed by a quote. $style->quotePrefix == true

What are the steps to reproduce?

I am not able to understand what is causing this, nor to produce a minimal reproduciable example.

Which versions of PhpSpreadsheet and PHP are affected?

My code has been breaking since 033ed16 "Dde call safe handling" but I do not think that the problems comes from it as the styles are explicitly mentioning quotePrefix. I have unsuccessfully tried to understand what might be wrong here.

I am opening this ticket so people can report encounterx with similar problems.

[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.

[frantzmiccoli]

Not stale.

[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.

[melkamar]

Not stale.

[oleibman]

Might you be able to supply a code sample and/or spreadsheet that demonstrates your problem? I certainly can't figure out what the problem is from the information currently available in the ticket.

[endrsmar]

This problem is somehow linked to cell formatting, we've received two separate excel files from a customer that demonstrate this problem, unfortunately I can't of course provide those directly. I'm trying to produce an example sheet but so far I couldn't find the correct combination of formula/formatting that leads to this issue. Removing formatting from cells fixes this problem.