XMLWriter translate Single QUOTE to unwanted ' since PHP8.1

[alaindev]

Single QUOTE translated to unwanted '
Since PHP8.1
htmlspecialchars default parameters switched from
ENT_COMPAT
to
ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401
=> see Changelog ¶

as a result
PhpSpreadsheet Saved with XMLWriter no longger has text with QUOTES but text with '

processing the XLSX file with 'Tiny but Strong' for exemple fails because of wrong syntax due to this new data and semicolon

=> fix is forcing ENT_COMPAT when calling htmlspecialchars in XMLWriter::writeRawData

public function writeRawData($rawTextData)
{
    if (is_array($rawTextData)) {
        $rawTextData = implode("\n", $rawTextData);
    }

    return $this->writeRaw(htmlspecialchars($rawTextData, ENT_COMPAT));
}

[oleibman]

First, this is not a bug with either PhpSpreadsheet or Php. If your XML reader is not converting ' to apostrophe, then that is where the bug lies, and where it should be fixed.

That being said, PhpSpreadsheet's behavior was changed with PR #4540 in July, and that was part of release 4.5.0 (and all later releases) which has been available since July 23.

[oleibman]

Closing, already "fixed".